| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
IF formula reference error
So =IF(U4="","",IF(U4<'MDA Portfolio Summary'!H8,"ACQUIRE",IF(U4'MDA
Portfolio Summary'!J8,"REDUCE",""))) was working, but now i get a REF error. the values in H8 and J8 are percentages, and U4 is also a formula result as a percentage. is this why i get a ref error, i cant find anything else wrong |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL ERROR - series formula is too long | Excel Worksheet Functions | |||
| Formula syntax error - chinese and gibberish | Excel Discussion (Misc queries) | |||
| Is it Possible in a formula to have a formula for cell reference? | Excel Worksheet Functions | |||
| Need formula for sheet & cell reference | Excel Worksheet Functions | |||
| Formula Error | Excel Discussion (Misc queries) | |||
Threaded Mode
