Multiple IF factors Question

[TenMostWanted]

Hello all,

I'm trying to get the "H" column to return the following:

IF D2<10, "NO"
IF D2<10 and F2>E2, "OK"
IF D2 >10 and F2>E2, "OVRSHP"

IFquestion.xlsx - Excel.jpg

Please help if you can simplify this for me! I have some other solutions, but I'd prefer to make the above work.

Thanks,
Brian

[joris moerings]

Hi,

try this: IF(D2<10,if(F2>E2,"OK","NO"),if(F2>E2,"OVRSHP,""))

[jason.b75]

Try

=IF(F2>E2,IF(D2>10,"OVERSHP","OK"),"NO")

I've assumed that IF D2<10, "NO" should be IF D2<10 and F2<E2, "NO", given that there is no result for D2>10 and F2<E2, I've assumed that this scenaio should never occur, so this combination is not checked by the formula.

[TenMostWanted]

Thank you both for the fast replies!

Jason, your assumption was correct and this formula worked perfectly!

-Brian