Hi Andy
Try this
=IF(D1=0,IF(C1=0,IF(B1=0,"B1=0",E2-B1),E2-C1),E2-D1)

Not sure what you mean by the "and so on" but you can put that in where it
says "B1=0" (the case where all 3 are 0)


- Search


"~Andy~" wrote:


Hi all - I'm not sure if it's an IF statement I need - but if it is then
I would like to know how to ignore cells with zero as the number.

Let me explain further:

A B C D
E F
1 -Threshold 1333.3 0.0 0.0 1000.0 4333.3
2 Threshold cum. 1333.3 0 0 2333.3 6666.7-

Cell E1 should display cell E2 minus cell D1 but only if D1 is not
zero. If it is zero then it should subtract C1 but again only if it is
not zero. Again if C1 is zero it should go to B1 and so on.

I hope this is explained clearly enough. It's giving me some problems
this one and I would appreciate some help.

Many Thanks,

Andy:)


--
~Andy~
------------------------------------------------------------------------
~Andy~'s Profile: http://www.excelforum.com/member.php...o&userid=17751
View this thread: http://www.excelforum.com/showthread...hreadid=488796