Excel中進(jìn)行表格對(duì)數(shù)和指數(shù)的計(jì)算方法
Excel中對(duì)數(shù)和指數(shù)的計(jì)算方法,具體該怎么去進(jìn)行操作?今天,學(xué)習(xí)啦小編就教大家在Excel中進(jìn)行表格對(duì)數(shù)和指數(shù)的計(jì)算方法。
Excel中進(jìn)行表格對(duì)數(shù)和指數(shù)的計(jì)算步驟
對(duì)數(shù)計(jì)算:
方法:=LOG(NUMBER,BASE)
參數(shù):NUMBER:對(duì)數(shù)真實(shí)數(shù)
BASE:對(duì)數(shù)底數(shù)
注:如果對(duì)數(shù)真實(shí)數(shù)是自然對(duì)數(shù)e,可以用EXP(1)代替
指數(shù)計(jì)算:
方法:=POWER(NUMBER,BASE)
參數(shù):NUMBER:底數(shù)
BASE:指數(shù)項(xiàng)
方法: = EXP(BASE)
參數(shù):底數(shù)為自然對(duì)數(shù)e
BASE:指數(shù)項(xiàng)
看過(guò)Excel中進(jìn)行表格對(duì)數(shù)和指數(shù)的計(jì)算還看了:
2.Excel中進(jìn)行使用對(duì)數(shù)函數(shù)的操作方法
3.excel對(duì)數(shù)函數(shù)的使用方法