Missing a Variant?

[TimW1725]

In an attempt to pay out remaining revenue owed. B25, I've created a formula that would show this (D19+D20-A2)

However, I am not sure how to make it an option with the current formula in cell B25 [$185.00]  =IF(D23<1,D19,+IF(D23<AB2,AF3,D19-D23))

Based on the earned FNL revenue $185.00 in Cell D19, and the earned Revenue of $545.00 in Cell D20, subtracted from the promised revenue of $650.00 in Cell A2, the remaining revenue owed from D19 is $80.00.

I'd like to show this in Cell B25. Is this possible, or do I have too many arrangements?  Thanks!

 

[#2]

@TimW1725 You need to clarify a bit. Where do D23, AB2 and AF3 come into play? I can see D23 being zero. But what about the others?

However, in general terms, if you want to make the arguments on a formula like (D19+D20-A2) conditional, based on the cells mentioned earlier, you could perhaps write something like this:

=IF( D23<1, D19 + IF( D23<AB2, AF3, D20 - A2 ), 0)

[#3]

Thanks Riny,
The suggestion returned a VALUE error.

The formulas you question relate to the [Approve FNL Exceptioms] box, if B19 is less than B20 then B19 is owed.

However let's say B20 = $525, and B19=$50,

The promised amount in A2 = $550.00, bringing the total in D24 to $575.00, this means we still owe $25.00 which should populate in B25.

However, if the amount in A2 was increased, the value would show an incorrect amount, so it to, would need to register $0.00 in this case.

Hmmmmmm I'm not sure this can be done.

[#4]

@TimW1725 Don't think it's impossible, though don't understand what you want. Forgive my ignorance.

[#5]

Non worries at all, thank you for assisting.