Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |