Two formulas in one cell

  • Thread starter Thread starter something68
  • Start date Start date
S

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�
 
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
 
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",""))
 
Back
Top