• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

IF statement with multiple criteria and MAX round if possible


I would like some assistance to create a formula that includes
If column A is blank "TRUE"​
If column C and column D = 0 "TRUE"​
If the difference between column C and Column D is Less than 5.00 or -5.00 "TRUE"​
I hope I have articulated this correctly, thanks Kelli​


Ali 'You are amazing' that is perfect, thank you so much.

take care! Kelli
Hi Ali, I have one more condition that hasn't come to light until just now.

I've updated the formula to show as Yes or No if there is an increase, but is there a way of it returning a No result if it is a negative figure i.e. not an increase?

I hope this makes sense.

thanks, Kelli


Last edited: