Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

IF Formula not computing properly for all items

818 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Megan_Feasel
5 - Automation Enthusiast
5 - Automation Enthusiast

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

1 Reply 1

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