Conditional Formula

  • Thread starter Thread starter tqdinh22
  • Start date Start date
T

tqdinh22

Is there a conditional formula to do something like this...

If cell A3 equals "HOUR" or "DAY" then display "=cellA1
cellA2"....but if cell A3 equals "FIXED" then displace "=CELLA2"

Sorry if this is a bad description, I am a beginner with excel...
 
=IF(OR(A3="HOUR",A3="DAY"),A1*A2,IF(A3="FIXED",A2,""))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Back
Top