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
Thanks again

"Max" wrote:

Try something like:

=IF(U5="","",IF(U5<='MDA Portfolio Summary'!H2,"ACQUIRE",IF(U5='MDA
Portfolio Summary'!J2,"REDUCE","")))

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Micayla Bergen" wrote in message
...
IF(OR(U5=<'MDA Portfolio Summary'!H2,ACQUIRE,U5='MDA Portfolio
Summary'!J2,
REDUCE}))
Thanks Max. now i want to have a cell return either Acquireif it is less
than H2 or Reduce if it is more than J2