i want my cell to return a value if J5 is 1 or 2 (which themselves are
results of formulas)
i have this thusfar
=IF(J6=1,"SELL?","",(IF(J6=2,"SELL?","")))

Try: =IF(OR(J5={1,2}),"SELL?","")

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Micayla Bergen" wrote in message
...
i want my cell to return a value if J5 is 1 or 2 (which themselves are
results of formulas)
i have this thusfar
=IF(J6=1,"SELL?","",(IF(J6=2,"SELL?","")))

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

"Max" wrote:

Try: =IF(OR(J5={1,2}),"SELL?","")

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Micayla Bergen" wrote in message
...
i want my cell to return a value if J5 is 1 or 2 (which themselves are
results of formulas)
i have this thusfar
=IF(J6=1,"SELL?","",(IF(J6=2,"SELL?","")))

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

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

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?

"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

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?