Maybe something has happened to the reference source 'MDAPortfolio
Summary'!J8..........

Vaya con Dios,
Chuck, CABGx3





"Micayla Bergen" wrote in message
...
Hi Max
the values in H8 and J8 are just numbers as percentages, there are no
formulas in those cells. U4 is a formula but shows the result not a ref
error

"Max" wrote:

Don't think the percentages in U4, J8 and H8 are an issue causing #REF!
Maybe one of the 3 precedent cells (U4, J8 and H8) is evaluating to
#REF!
That's all it takes to cause the IF formula to, in turn, evaluate to
#REF!
Try a re-check on the formulas in the 3 precedent cells (U4, J8 and H8)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Micayla Bergen" wrote in
message
...
I have =IF(U4="","",IF(U4<'MDA Portfolio
Summary'!H8,"ACQUIRE",IF(U4'MDA
Portfolio Summary'!J8,"REDUCE",""))) which should work but it actually
returns a REF error. i havent deleted anything so dont understand the
error.
the answers in U4 and J and H8 are percentages. Is this the issue?