PC Review


Reply
Thread Tools Rate Thread

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
 
Reply With Quote
 
 
 
 
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.
 
Reply With Quote
 
 
 
 
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:26 AM.