Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |