• 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

    Hui...

  • 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

Hello,

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​
 

Attachments

  • Chandoo - IF TRUE incl. rounding.xlsx
    21.4 KB · Views: 3
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
 

Attachments

  • Chandoo - IF TRUE then apply sum incl. rounding.xlsx
    23.1 KB · Views: 5
Last edited:
Back
Top