I’m working on an XP that has a scene where a user can select cost shares. The price of the cost shares chosen is subtracted from the total of a membership. In the next scene, the total that the user would have to pay for their membership after their selected cost shares are applied is shown, saying “Congratulations! With your selected cost shares, your membership would only cost you:” and then the total is shown below.
I’ve got the calculator in an Excel doc, and it works well. I have the cost of membership ($15,000) in one cell (A2), the next cell holds the total from a shopping cart (B2). The final cell (C2) has the B2 (cost shares from shopping cart) subtracted from the membership (A2)
HOWEVER! I’m trying to come up with a formula that would keep the total the user would have to pay (C2) from showing 0 and below (we don’t want it to say that the user would have to pay -$200, for example). Once it hits zero (or below), I would like it to say “Free!”
How would I implement this? Would I come up with a formula within Excel, and what would it look like? Or would I need to create a custom script within Intuiface to do this? Help! Formulas can melt my brain at times.
Thanks in advance!