Nested If issue

[andrewb90]

Hello all,

I have this formula that doesn't seem to be doing what I want:

=IF(C12>=KDS!D6,KDS!D6-C12,IF(C12<=KDS!D4,((KDS!D4-C12)*2)+KDS!D5-KDS!D4,IF(C12<=KDS!D5,KDS!D5-C12,0)))

C12 has a value of 3:51.
D4 is 3:52
D5 is 4:04
D6 is 4:14

What the formula is supposed to do is if C12 is lower than D4, my result should take the difference between the 2 multiplied by 2 plus the difference between D4 & D5 (should be 14)
If C12 is Higher than D4 but lower than D5 it should be the difference.
And if C12 is higher than D6 the difference (negative) would be displayed, anything else would be 0.

Any help would be wonderful!

 

[SQUIDD]

Hi

Does this work for you.

=IF(C12 < D4,D5-D4+(D4-C12)*2,IF(AND(C12 > D4,C12 < D5),D5-D4,IF(C12 > D6,"NEGATIVE","")))
<d4,d5-d4+(d4-c12)*2,if(and(c12><d5),d5-d4,if(c12>

you will need to add your sheet refrences where required.

dave</d5),d5-d4,if(c12></d4,d5-d4+(d4-c12)*2,if(and(c12>