N
Nathan323
Howdy all,
I have a roster, for which I am designing a sheet to calculate total
wages. Different hourly amounts for week day, evening, saturday day,
evening, sunday day, evening. So far I have this:
=IF(OR(A5=$F$14,A5=$F$15,A5=$F$16,A5=$F$17,A5=$F$18,A5=$I$14,A5=$I$15,A5=$I$16,A5=$I$17,A5=$I$18)*AND(C5="day"),187.11,(C5="night")*181.26)
The references are to a different part of the sheet where i have the
names of the week listed. I paste my roster (DAY OF THE WEEK column, &
DAY OR EVENING column) into an area of the sheet. This all works fine,
but its so far not taking into account the saturday/sunday data. I
basically need to cram more IF's in there I guess (Excel novice), I
just cant work out the right syntax.
Any help would be greatly appreciated.
Cheers, Nathan
I have a roster, for which I am designing a sheet to calculate total
wages. Different hourly amounts for week day, evening, saturday day,
evening, sunday day, evening. So far I have this:
=IF(OR(A5=$F$14,A5=$F$15,A5=$F$16,A5=$F$17,A5=$F$18,A5=$I$14,A5=$I$15,A5=$I$16,A5=$I$17,A5=$I$18)*AND(C5="day"),187.11,(C5="night")*181.26)
The references are to a different part of the sheet where i have the
names of the week listed. I paste my roster (DAY OF THE WEEK column, &
DAY OR EVENING column) into an area of the sheet. This all works fine,
but its so far not taking into account the saturday/sunday data. I
basically need to cram more IF's in there I guess (Excel novice), I
just cant work out the right syntax.
Any help would be greatly appreciated.
Cheers, Nathan