Anti-log formula in OpenOffice Calc or Excel.

  octal 19:04 01 Sep 2006

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


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

Dell XPS 13 9370 (2018) review

Best Keyboards for Designers & Artists

What to ask Siri on the HomePod

Meilleurs VPN (2018)