Would like a "Nested IF" Alternative

[Rosstamon]

I have a spreadseet where I am tracking several thousand rows of purchases and it will continuously grow.

I have a sort of run on Nested If statement and I'm wondering if there is a way to make this cleaner.

Here it is:

=IF(G2373="On Hand",0,IF(N2373="MP",0,IF(S2373="Canceled",0,IF(T2373="Canceled",0,IF(T2373="Partially Received",Z2373*J2373,J2373*K2373)))))

What I'm trying to accomplish is:
if G="On Hand", or if N="MP", or if S="Canceled", or if T="Canceled" then in each case or all cases this cell should = 0 (zero) otherwise if T="Partially Received" then Z*J, otherwise if none of these are true then J*K

Should I just stick with the "Nested IF" or is there an easier and/or cleaner way to do this?

Thanks,
Rosstaman

 

[Scott Huish]

=IF(OR(G273="On Hand",N2373="MP",S2373="Cancelled"),0,J2373*IF(T2373="Partially Received",Z2373,K2373))

 

[Rosstamon]

HOTPEPPER,
Yes that worked. I appreciate your help. Do you know if this formula will use less processor than my Nested If string and thus speed up response time?

The reason I asked for an alternative formula is with so many Nested Ifs on several thousand lines, I'm thinking it's creating latency. Possible?

Thanks again.

 

[Scott Huish]

I can't say for certain, but I think it would.