Help on combining two IF Statements

  • Thread starter Thread starter Sunflower
  • Start date Start date
S

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
 
Sunflower said:
How do I combine two IF statements?
=IF(C12="PTO",-8,C12*$E$3)
OR
=IF(C12="HOLIDAY",0,C12*$E$3)
Click to expand...

Perhaps:

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

PS: In the future, post to only one NG, or crosspost.
 
Perhaps:

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

PS:  In the future, post to only one NG, or crosspost.
Click to expand...

Thanks

Sorry for the double posting...
I am not sure how to "crosspost",
However in the future I will not post to more than one group
 
Back
Top