I had this formula set up for calculating the remainder balance due after a client has paid the retainer. It had been working fine and then I tried to add another IF statement to the formula and now even after deleting the added IF statement it still doesn’t work. I have a screen shot here. Can anyone see an issue with this formula?
Hi @allegro23,
I think you need to remove the closing parenthese immediately after 0.50.
MULTIPLY(0.50,{RTPB})