ExcelBanter - Help on combining two IF Statements

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Help on combining two IF Statements (https://www.excelbanter.com/new-users-excel/254245-help-combining-two-if-statements.html)

Sunflower[_2_]

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

Joe User[_2_]

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))

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

Sunflower[_2_]

Help on combining two IF Statements

On Jan 24, 11:22*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))

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

All times are GMT +1. The time now is 07:53 AM.