Combining more than one "IF" function

**Pegasus15** · 01-30-2009, 06:11 PM

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.

**mewingkitty** · 01-30-2009, 06:28 PM

Please Login or Register  to view this content.

It'd be something like that.

I've used the Excel number codes for dates as the greater than less than values, not too sure about dates on here, might need to go about that a different way, but the rest of the formula is correct, I believe. This'd be a lot easier with a sample worksheet so that I knew what type of formatting your cells have.

mew!

EDIT!
Had the wrong value in there for December 1, see proper code above.

**Pegasus15** · 01-30-2009, 06:37 PM

I've attached basically what it looks like.

I should probably explain that it refers to a part-time job and that the rate per hour on a Sunday is €13 but on a Sunday up to Christmas in December (excluding Christmas Day, as the place won't be open then but including Christmas Eve) is €18.

**JBeaucaire** · 01-30-2009, 09:12 PM

Originally Posted by Pegasus15

If cell A13 says "Sunday" in it, then I want F13 to display 13, otherwise 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.

This is what I came up with, just copy it down.

=IF($A13<>"Sunday",9,IF($B13<40148,13,IF($B13>40171,13,18)))

or even...

=IF($A13<>"Sunday",9,IF(OR($B13<40148,$B13>40171),13,18))