Combining IF, OR, and the AND logical Functions
Well, I think you want to do something like this:
=IF(OR(E8="DG F",E8="DG M"),IF(D8=1,ReqPO!T7,IF(D8=0,9999,"n/a")),"n/
a")
but the "n/a" indicates where you have not fully defined the problem.
Hope this helps.
Pete
On Jul 30, 5:29*pm, Eden397 wrote:
Hi,
I am trying to write a formula that looks at column E and determines if it
has in it the words DG F or DG M. *If it has either of those words, then I
want the formula to go to Column E and see if there is a 1 or a 0. *If a 1,
then go to another worksheet and take the value from there. *If a 0, replace
with 9999. *Below is sort of what I was thinking but it comes back with an
error on the D8=0. *Can anyone help? *Thanks, Eden 397
IF(E8="Dg F",or(if(e8="DG M",AND(if(D8=0)=True),1,ReqPO!T7)))
|