AND vs. OR

  • Thread starter Thread starter Kiki
  • Start date Start date
K

Kiki

Can someone help with a cell formula? Here's preliminary,
but am I not using correct characters? for cell X2,If D32
= "I" AND E32 = "H" then insert value in C32 to X2.
Hope it's clear what I'm trying to do.
THanks
 
=IF(AND(D32="I",E32="H"),C32,something else)

Replace the something else with whatever you want in X2 if the AND statement
is false.
 
Back
Top