formulas with <
 

Hi - I am using a spreadsheet with formulas setup by someone else and the
formula is reading:
=if (AA110<"",AA110,if (g110<10,G110,AA110*10))
My interpretation is that it should read:
=if(AA110="",AA110 etc. (ie. if AA110 has nothing in it, make the cell blank)

Or does the < mean something else?

There is more in the formula but it refers to sheets that do not exist in
this workbook thus I presume are disregarded so if AA110 does have something
in it, the formula then does the 2nd if statement.
Hoping someone can clarify!
Thanks

formulas with <
 

Hi Lynn

< means NOT equal to
So what the formula says (in words) is

If AA110 is not empty then
use the value from AA110
otherwise if G110 is less than 10, take the value in G110
or else take the value in AA110 multiplied by 10

--
Regards
Roger Govier

"Lynn" wrote in message
...
Hi - I am using a spreadsheet with formulas setup by someone else and the
formula is reading:
=if (AA110<"",AA110,if (g110<10,G110,AA110*10))
My interpretation is that it should read:
=if(AA110="",AA110 etc. (ie. if AA110 has nothing in it, make the cell
blank)

Or does the < mean something else?

There is more in the formula but it refers to sheets that do not exist in
this workbook thus I presume are disregarded so if AA110 does have
something
in it, the formula then does the 2nd if statement.
Hoping someone can clarify!
Thanks

__________ Information from ESET Smart Security, version of virus
signature database 4767 (20100113) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4767 (20100113) __________

The message was checked by ESET Smart Security.

http://www.eset.com