I was thinking of writing multiple if statements but I don't think that will do the trick. What I would like is a formula to look at both column D & E. If column D is not null, then look for the next value in column D and subtract the values in column C. The same would apply if the value in column E is not null.
column B in the attachment is what the values should look like.
Last edited by AccountingJ; 03-21-2018 at 04:28 PM.
Rows 5 and 6 both have amounts in column D and none n E. Why in Row 5 do you subtract from Row 6, but in Row 6 subtract from Row 8?
Try this in B5:
=MAX(MIN(IF(IF(D5="",E$5:E$10<>"",D$5:D$10<>"")*(C$5:C$10>C5),C$5:C$10))-C5,0) Ctrl Shift Enter
Drag the formula down column B.
Also, including the country that you are located in helps us know which regional settings your version of Excel will have.
"Behind a Keyboard" doesn't help us much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks