struggling to get 2 IF formulas to work in one cell

Hi

I hope someone can point me in the right direction.

I want a single cell to populate with "Yes" using data from other cells but I cant get it to work.

What I am hoping in one cell is a YES if:

R5+R6=12 then show YES
&
R8=4 then show YES

If no data is present in R5,R6,R8 or they show as 0 then leave blank

Any help would be gratefully received
Thank you

many thanks chris, I think this is where I cam getting confused with what to specify in the formula.
I am not sure to be honest.

I am wanting the formula to show a YES if a trigger level is met, the trigger level is two stage, 12 days (taken from cells R5+R6), or 4 occasions (taken from cell R8)

I would need it to be just blank
Craig

is that what you wanted;

=OR(R5+R6=12,R8=4) ?

and IF(OR(R5+R6=12,R8=4), "Yes","") will give you yes or blank

many thanks Chris and AlanY, I have tried both

=if(r5+r6=12,"yes",if(r8=4,"yes",""))

IF(OR(R5+R6=12,R8=4), "Yes","")

and they work, I am spoilt for choice now which to use.

Thanks again

I'm leaning towards AlanY but seems like an AND vs OR

=IF(AND(R5+R6=12,R8=4), "YES", "")

Originally Posted by TxCPA

I'm leaning towards AlanY but seems like an AND vs OR

=IF(AND(R5+R6=12,R8=4), "YES", "")

but that wouldn't work for OP's criteria