Hi, I have attached a spreadsheet which I need help to finish completing.
What I am hoping from the sheet is for it to mark attendance and calculate fees.
You will see it is marked with columns A, P and F under each day of the week. The idea for these columns is that the manager would mark the relevant one (by typing '1', this will display a tick). If a child is in both AM and PM they would just mark the 'All Day' column (F). If a child is in 5 days a week (Mon-Fri), then the manager would just text the 'Full Time' column.
All the AM sessions are £22
All the PM sessions are £26
If in a full day its £46.80
If in full time (All day, 5 days a week) its £208
The column I need the formula in is the FEES column.
I hope somebody knows how to make this formula! Help will be very much appreciated.
Thanks in advance
Bookmarks