Hi there
I need to use a complicated formula, but can't work out how it should read
I have columns
I - Nomination Date
K - Expected Start date
L - Cancellation Date
N - Date of Enrolment
O- Date of Attendance
U - Attendance Complete (Y or N)
V - Failed to Complete Component (Y or N)
People who
cancel their place after being nominated but before enrolment should pay nothing (Date in Cancellation and Nomination fields, but Enrolment field will be empty).
cancel their place after enrolment but before start date will be subject to £1000 (Date in Cancellation, Nomination and Enrolment fields)
do not enrol or cancel their place or attend will be subject to £1000 (so fields L, N AND O will be empty)
fail to complete component will be due £200 ("Y" will be in column "V")
fail to complete Attendance will be due £200 ("N" will be in column "U")
I need to show the cancellation charge due (£0, £200 or £1000) in another column
Can anyone help?
Thanks
Bookmarks