Results 1 to 2 of 2

Thread: How to combine two IF Statements in Microsoft Excel

  1. #1
    Join Date
    Dec 2011
    Posts
    62

    How to combine two IF Statements in Microsoft Excel

    Hi friends, recently I was trying to create macros that I can use for my Excel sheet, so I have just get stuck there at one place that I don’t know how to combine the two IF Statements in Microsoft Excel. I have tried many tricks but still am not able to combine two IF Statements. I just want to know 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

  2. #2
    Join Date
    May 2011
    Posts
    523

    Re: How to combine two IF Statements in Microsoft Excel

    According to my information you should try this out, maybe it will help you out. =IF (C12="PTO", -8, IF (C12="HOLIDAY", 0, C12*$E$3))

Similar Threads

  1. Replies: 2
    Last Post: 17-02-2012, 01:00 PM
  2. Replies: 2
    Last Post: 13-01-2012, 05:27 PM
  3. How to combine data in duplicate rows in MS excel
    By Virginia in forum Windows Software
    Replies: 7
    Last Post: 10-07-2011, 11:13 AM
  4. Difference between DML statements and DDL statements
    By Prashobh Mallu in forum Software Development
    Replies: 5
    Last Post: 11-01-2010, 01:07 PM
  5. Replies: 2
    Last Post: 24-11-2008, 05:48 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,714,011,229.76559 seconds with 17 queries