# Holidays and Monday formula

I have this formula where it works for Holidays to find multiplier to mulitiply value by.  I need now to add
If a Monday multiply value starting at  O11 by 3.

=IFERROR(VLOOKUP(TODAY(),Holidays!B\$2:D\$9,3,0),1)*E11*J11

I have attached a sample file
ee---workdays-multipliers--3-.zip
###### Who is Participating?

x

Commented:
If you only want to multiply up if it's not also a holiday then you need to combine your conditions:
``````=IFERROR(VLOOKUP(TODAY(),Holidays!B\$2:D\$9,3,0),IF(WEEKDAY(TODAY(),1)=2,3,1))*E11*J11
``````
0

Commented:
``````=IFERROR(VLOOKUP(TODAY(),Holidays!B\$2:D\$9,3,0),1)*IF(WEEKDAY(TODAY(),1)=2,3,1)*E11*J11
``````
0

Author Commented:
So would I use this one for if there are Holidays or not.  I need for it to calculate by 3 if it is just a monday and if it is a Holiday - it will use the table.

=IFERROR(VLOOKUP(TODAY(),Holidays!B\$2:D\$9,3,0),IF(WEEKDAY(TODAY(),1)=2,3,1))*E11*J11
0

Author Commented:
Can you explain the formula

IF(WEEKDAY(TODAY(),1)=2,3,1

Is the 3 going to be the multiplier if today is a Monday?
0

Author Commented:
I am confused with two answers -  I always will calculate Monday except when it is a Holiday.   When Monday is a Holiday - it will look at Tuesday to calculate 4 days which is used from Holidays tab.

So I still think I will use this one.
=IFERROR(VLOOKUP(TODAY(),Holidays!B\$2:D\$9,3,0),IF(WEEKDAY(TODAY(),1)=2,3,1))*E11*J11
0

Commented:
Yes that formula does holiday preferentially (looking up) and if not checks for Monday.

Yes, the 3 is the multiplier, the 1 is to leave it untouched.

"I always will calculate Monday except when it is a Holiday."
If it's a holiday, it uses the multiple looked up from the holiday sheet, otherwise it checks if it's a Monday, i.e. if it's both a holiday and a monday then it just looks to the holiday sheet and ignores the fact it's a monday.

"it will look at Tuesday to calculate 4 days which is used from Holidays tab"
I don't know what you mean by this?
0

Author Commented:
Great Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.