# Help on combining two IF Statements

Sunflower
Guest
Posts: n/a

 24th Jan 2010
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
Guest
Posts: n/a

 24th Jan 2010
"Sunflower" <(E-Mail Removed)> 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
Guest
Posts: n/a

 24th Jan 2010
On Jan 24, 11:22*am, "Joe User" <joeu2004> wrote:
> "Sunflower" <luvsunflow...@gmail.com> 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

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Sunflower Microsoft Excel Worksheet Functions 3 24th Jan 2010 08:59 PM =?Utf-8?B?dHJhaW5iaWY=?= Microsoft Access 5 18th Nov 2005 10:04 PM =?Utf-8?B?RXhjZWxlcmF0ZTIwMDQ=?= Microsoft Excel Misc 1 19th Mar 2004 04:26 AM Excel-erate2004 Microsoft Excel Misc 5 19th Mar 2004 12:47 AM -\$- Windows XP Internet Explorer 2 21st Dec 2003 11:45 PM

Features