Two formulas in one cell

[something68]

Sometimes I cannot respond whether an answer was helpful or not, but I am
desperate for help with the following:

D8 shows “H†and D9 shows “8â€
E8 shows “MO†and E9 shows “8â€
How can I have column V8 show “8â€, “8â€?

ALSO

D8 shows “S†and D9 shows “8â€
E8 shows “SF†and E9 shows “8â€
How can I have column R8 show “8†and column U8 show “8�

 

[Eduardo]

Hi,

I assumed you meant if cell doesn't match you want blank space

=if(and(D8="H",D9=8),8,"")

=if(and(E8="MO",E9=8,8,"")

change cells to fit your needs in the other cases

hopes this helps

 

[Eduardo]

Hi,
I was thinking that maybe what you need is a combination

=IF(AND($d$9=8,$e$9=8),IF(AND($D$8="H",$E$8="MO"),"8",""))