Excel inverse log function?

jklein · May 13th, 2002, 09:47 AM

Does anyone know if there is an inverse log function in Excel? I found a LOGINV function but it asked for parameters I'm not familiar with. I'm using a dB loss equation "dB = Log(Pout/Pin)*10" rearranged to calculate expected output power given the nominal dB loss and input power so I need to compute inverse log in the process. Thanks for any help on this.

Jeff

Jay Petrulis · May 13th, 2002, 09:57 AM

Hi Jeff,

Use
=EXP(exponent)
to take the inverse of the natural logarithm.

Use
10^(exponent)
or =POWER(10,exponent) to take the inverse base10 logarithm/

HTH,
Jay

jklein · May 13th, 2002, 10:59 AM

Thanks, Jay. It works great.

Jeff

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 13th, 2002, 09:47 AM	#1
jklein New Member Join Date: May 2002 Location: Baltimore Posts: 7	Does anyone know if there is an inverse log function in Excel? I found a LOGINV function but it asked for parameters I'm not familiar with. I'm using a dB loss equation "dB = Log(Pout/Pin)*10" rearranged to calculate expected output power given the nominal dB loss and input power so I need to compute inverse log in the process. Thanks for any help on this. Jeff

May 13th, 2002, 09:57 AM	#2
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Hi Jeff, Use =EXP(exponent) to take the inverse of the natural logarithm. Use 10^(exponent) or =POWER(10,exponent) to take the inverse base10 logarithm/ HTH, Jay

May 13th, 2002, 10:59 AM	#3
jklein New Member Join Date: May 2002 Location: Baltimore Posts: 7	Thanks, Jay. It works great. Jeff