IF Formula not computing properly for all items

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!

2020-03-25 10_53_32-Window

Hi @Megan_Feasel,

For the IF statement, it seems correct, but you can change the argument to =1, this means that the box is checked.

BR,
Mo