Help on combining two IF statements

[Sunflower]

How do I combine two IF statements?

=IF(C12="PTO",-8,C12*$E$3)

OR

=IF(C12="HOLIDAY",0,C12*$E$3)



Thanks for any and all help

 

[Joe User]

How do I combine two IF statements?
=IF(C12="PTO",-8,C12*$E$3)
OR
=IF(C12="HOLIDAY",0,C12*$E$3)

Perhaps:

=IF(C12="PTO", -8, IF(C12="HOLIDAY", 0, C12*$E$3))

 

[Sunflower]

Perhaps:

=IF(C12="PTO", -8, IF(C12="HOLIDAY", 0, C12*$E$3))

Thanks...works

 

[Mike H]

Hi,

=IF(C12="PTO",-8,IF(C12="Holiday",0,C12*$E$3))

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.