IF/ELSE Function assistance

**kaye.roberts393** · 02-27-2013, 03:45 PM

Hello, I'm trying to make 3 different functions for corresponding days of the week. For example
If it is Monday-Thursday I need the Sheets in the workbook that are Mon-Thu to calculate certain cells to the number 80. I also have formulas within these cells which will probably need to be changed if I can figure out how to use the IF/ELSE function. My entire workbook is a month long, so when I change the date in new workbooks I also need this function to recognize that all the sheets will be changing as well, since the first of the month isn't always going to start on the same day. help..?

**oeldere** · 02-27-2013, 03:53 PM

Make one sheet with all data (for the whole year).

After that you can easy use a formula per column.

**kaye.roberts393** · 02-27-2013, 04:19 PM

=IF(F2:H2="Monday",80,IF(F2:H2="Tuesday",80,IF(F2:H2="Wednesday",80,IF(F2:H2="Thursday",80,IF(F2:H2="Friday",70,IF(F2:H2="Saturday",60,IF(F2:H2="Sunday",60)))))))

This is the formula I'm using now and it's coming up as an error... Is it because I am only using the day and not the date?

**oeldere** · 02-27-2013, 04:24 PM

Please Login or Register  to view this content.

You can only look up in 1 cell with this formula:

So the syntax should be:

If(f1="Monday",80;IF(etc)

But I would advice you to make an table on your sheet with the days of the week in it (e.g. column Y)
In column Z you ad the value (e.g. 80)

Then you can use Vlookup for your problem.

=Vlookup($f2,$y$2:$z$9,2,0)

and drag down.