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 field called Purchase Price: example ($22,556.03)
I have a numerical currency field called Closing cost : ($1950)
I have a currency formula field called Closing Cost – 400/2 ([Closing Cost]-400): ($750)
This is the field I am having trouble with field Closing -400/2-IVA
Closing Cost -400/2/1.16 ( this number should be 667.10) it comes out at 4843.75
Last field is Currency formula
[Purchase Price]*0.33+[Closing Cost minus 400/2]-[Closing -400/2-IVA] This field should have a sum of 8111.59
It would be nice if I could do this all in one formula field but I am not great at formulas so I thought breaking it down step by step would work – so that the person using it in reports would be able to see step by step
I am lost and I am hoping someone can help me
thanks a bunch - hope that made sense