Results 1 to 5 of 5

Combining more than one "IF" function

Threaded View

  1. #1
    Registered User
    Join Date
    01-14-2009
    Location
    Ireland
    MS-Off Ver
    Excel 2003
    Posts
    6

    Combining more than one "IF" function

    Hello,

    I wonder if anybody could please help me with this. What I'm trying to do is as follows.

    If cell A13 says "Sunday" in it, then I want F13 to display 13, otherwise 9. No problem getting this bit, just used =IF(A13="Sunday",13,9). What I also need to add is that if A13 = Sunday AND B13 = 01/12/09 or 02/12/09 (or any other day until Christmas), then F13 = 18. But if A13 does say Sunday but isn't a day in December, then F13 = 13. And if A13 doesn't say Sunday and nor is B13 a date in December, then I need F13 to just display 9.

    I assume all this can be done with one very long IF function. I just haven't got a clue how to string it all together.

    Many thanks in advance.
    Last edited by Pegasus15; 01-31-2009 at 07:21 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1