LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #29   Report Post  
Old April 21st 12, 11:06 AM posted to rec.radio.amateur.antenna
external usenet poster
 
First recorded activity by RadioBanter: Sep 2007
Posts: 135
Default Be careful when using Excel

On Fri, 8 May 2009 18:36:08 +0200, "Antonio Vernucci"
wrote:

I think this message can be of interest for those using Excel for antenna
calculations.

Write in one cell: =(-A1^2 + 8) Note: the exponent of A1 is 2 (and not
2+8=10) because Excel performs squaring before summing

Write in another cell: =(8 - A1^2)

They look pretty much the same

But give A1 any non-zero value and see what happen.

73

Tony I0JX
Rome, Italy


That's funny.
I would improve for clarity by putting spaces between

Write in one cell: =(- A1^2 + 8) .......... (result xxx(censored)
Write in another cell: =(8 - A1^2).............(result x(censored))

The result is same a yours, despite the spaces.
You may also enter negative numbers in A1 and also
decimal numbers, everytime a surprise.


Another Microsoft blunder?


w.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
everyone better be careful while building those shortwave radios [email protected] Shortwave 9 April 14th 08 08:50 PM
Be careful replying to off topic messages here! (La Site Communique) Dave Boatanchors 0 February 10th 04 10:15 PM
Be Careful What you Say on The Air Girls Dwight Stewart General 2 December 18th 03 02:22 AM
Be Careful What you Say on The Air Girls Dwight Stewart Scanner 2 December 18th 03 02:22 AM
Be Careful What you Say on The Air Girls Dwight Stewart Shortwave 2 December 18th 03 02:22 AM


All times are GMT +1. The time now is 02:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 RadioBanter.
The comments are property of their posters.
 

About Us

"It's about Radio"

 

Copyright © 2017