Hi everyone
I am new to this forum and excel, so forgive me if this is a stupid / particularly simple question!
I am building a labour and wages tracking spreadsheet. It is nearly complete but I need assistance adding 1 formula which would calculate:
CELL NR7=Cell K7
However
If CELL K5= Saturday, then CELL NR7=CELLK7 * 1.5
and
If CELL K5= Sunday, then CELL NR7=CELLK7 * 2
and
If CELL K5= Bank Holiday, then CELL NR7=CELLK7 * 1.5
and
CELL K5= Christmas Day, then CELL NR7=CELLK7 * 2
and
If CELL K5= Good Friday, then CELL NR7=CELLK7 * 2
Hope someone can help!
Bookmarks