Help on combining two IF Statements

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
 
J

Joe User

Sunflower said:
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))

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

Sunflower

Perhaps:

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

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top