formulas with <>

  • Thread starter Thread starter Lynn
  • Start date Start date
L

Lynn

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
 
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 said:
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
Click to expand...

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

The message was checked by ESET Smart Security.

http://www.eset.com
 
Back
Top