I am trying to calculate the deposit required amount with an option to override that number.
Here is my Formula :
If([System Cost]*0.1<1000, [System Cost]*0.1,[System Cost]*0.1>xxx.xx,xxxx,[Deposit Override]>=0, [Deposit Override])
The Deposit override part is not working. If i move it to the front in the formula it worlds. please help.
[Deposit Override]>=0, [Deposit Override],
[System Cost]<1000, round([System Cost]*0.1,0.01),1000)
That says, if there is a deposit override, use it, else if the system cost is under $1,000, charge 10% of the system cost rounded to the penny, else charge $1,000.
The IF statement checks the conditions in order and takes the first true one it finds.
Then there was the issue of needing to differentiate between a blank and a zero in the deposit override.