Solved - Help with a formula
I am trying to build a formula and it's coming out with the wrong numbers. I am trying to replicate an excel spreadsheet. The formula they have is Total for this 8111.59 I have a numerical fi...
Forum Discussion
I think you're on the right track to have each piece of data sit in its own field; makes the formula easier to work with and debug later.
It looks like your formula is off for Closing Cost - 400 / 2 since you've indicated this value should be *750. My guess is you need to first subtract the 400 from closing cost, then divide by 2.
*([Closing Cost]-400) / 2 = 775 - this value is also what shows in the screenshot for the formula. If this should be 750 then one more in put is needed.
Since you already have a formula field doing this calculation, you only need to then refer to this field in your IVA field: [Closing Cost - 400 / 2] * 1.116 should then give you 668.10; even though you've noted 667.10. We are getting closer.
If this is true, then once you fix this your formula, all calculations should align.
What I did was made a separate Numerical field called Closing Tax- and I also separated the percentage for commission for Company - it was Purchase Price *33 but I decided in case that number changes to make a separate field
I had to split every thing up – as you can see until I add everything up the numbers are correct
Closing- 775.00
Closing/IVA -668.10
Percentage .33 – 7443.49
Should add up right
Then I take all those and add them up in Company Comm Total [Commission For Company]+[Closing Cost minus 400/2]+[Closing -400/2-IVA]
And it pukes - it's like it does not like all those formulas in one or do I need some kind of [ } on there?