Anti-log formula in OpenOffice Calc or Excel.

  octal 19:04 01 Sep 2006
Locked

I'm trying to convert dBW into Watts, I can do it OK on the calculator, but I'm trying to do it in OO Calc. The formula is:

26dBW/10 = 2.6 then the anti-log of 2.6 is 400

I think the formula will probably be the same in Excel as well.

I've just realised I've never had to do anti-logs in a spreadsheet before, so I haven't a clue, I bet its easy it always is :-)

  VoG II 19:06 01 Sep 2006

=10^A1

where A1 houses the number to be antilogged.

  octal 19:15 01 Sep 2006

Blast! I knew it would be something easy. I use Excel nearly everyday and sometimes the simplest things fox me.

Thanks once again, 398.11 Watts is close enough for me.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?