Forum Discussion
Missing a Variant?
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...
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.
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.
TimW1725 Don't think it's impossible, though don't understand what you want. Forgive my ignorance.
- Non worries at all, thank you for assisting.