I am having problems coming up with a solution for this, so I appreciate any help....
I have a formula in in Cell H16
If the value in H15 is Greater than the value of C15+D15, then H16 = D15+E15+D13
If the value in H15 is Less than the value of C15-E15, then H16 = D13
If the value in H15 is equal to or between the value of (C15+D15) and C15-E15), then H16 = (H15-(C15-E15))+D13

I have the formula below, which seems to be close, but doesn't quite work..
Thanks!
=(IF((IF(H15>=($C15-$E15),(H15-(($C15-$E15))+$D13),(IF(H15<($C15-$E15),$D13)))),(IF(H15>=($C15+$D15),((($C15+$D15+$E15))-($C15-$D15))))))