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

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