Help on combining two IF statements
 

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

Help on combining two IF statements
 

"Sunflower" wrote:
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))

Help on combining two IF statements
 

On Jan 24, 11:20*am, "Joe User" <joeu2004 wrote:
"Sunflower" wrote:
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))

Thanks...works

Help on combining two IF statements
 

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.


"Sunflower" wrote:

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
.