| 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 |
|
#2
|
|||
|
|||
|
Resolved in earlier thread:
http://tinyurl.com/b7wzk (culprit was a line-break in the pasted formula) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Micayla Bergen" wrote in message ... 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 |
| Reply |
| 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) | |||
Linear Mode
