Two formulas in one cell

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�
 
E

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
 
E

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",""))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top