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!

​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!   Read More

​