# IF statement with multiple criteria and MAX round if possible

#### Kelli Webb

##### Member
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

• 21.4 KB Views: 3

#### AliGW

##### Active Member
Is this what you mean?

=OR(A1="",AND(C1=0,D1=0),ABS(C1-D1)<5)

#### Kelli Webb

##### Member
Is this what you mean?

=OR(A1="",AND(C1=0,D1=0),ABS(C1-D1)<5)
Ali 'You are amazing' that is perfect, thank you so much.

take care! Kelli

#### Kelli Webb

##### Member
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

• 23.1 KB Views: 4
Last edited:

#### bosco_yip

##### Excel Ninja
Just add one more condition In your H2 formula , and the formula become >>

=IF((A2="")+(C2=0)*(D2=0)+(ABS(D2-F2)<5)+(F2<0),"No","Yes")

Regards

#### Kelli Webb

##### Member
Just add one more condition In your H2 formula , and the formula become >>

=IF((A2="")+(C2=0)*(D2=0)+(ABS(D2-F2)<5)+(F2<0),"No","Yes")

Regards
Champion Bosco_yip!! thank you, Kelli