Anti-log formula in OpenOffice Calc or Excel.

  octal 19:04 01 Sep 06
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 06

=10^A1

where A1 houses the number to be antilogged.

  octal 19:15 01 Sep 06

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.

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…