Hello,

This is my formula

IF({No RoE}>"",{Total Project}-{Deposit Paid},{Total Project}-{Deposit Paid}-{RoE Sent})

Basically it’s saying, if No RoE is checked, then I want to take the Total Project and subtract out the Deposit Paid, otherwise I want to take the Total Project and subtract out the Deposit Paid and subtract out the RoE Sent.

But…

I’m not getting the right amount for all of them.

Example… Total Project is $3227.75, I’m subtracting out the Deposit Paid of $1613.88 and I should be left with $1613.87 but it’s giving me an answer of $1613.88. How do I get it to give me the correct answer?

Thank you for your help!