Thread: Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nc nc is offline
external usenet poster
 
Posts: 119
Default Function

Fee list per term
Code description Code E (student yr =1) E (student yr =2) E (student yr
2) O (student yr =1) O (student yr =2) O (student yr 2)

Full-time F 1,263.33 1,363.33 1,316.67 3,180.00 3,820.00 3,820.00
Part-time P 631.67 681.67 658.33 1,590.00 1,910.00 1,910.00
Field-work L 626.67 681.67 658.33 626.67 681.67 658.33
Part-time field-work Z 313.33 341.67 330.00 313.33 341.67 330.00



Student name Student yr Mode Pattern Fee (maually calculated)
Tom 1 O FFF 9,540.00
Susan 2 E PPP 2,045.00
Sam 6 O PFF 9,550.00


I need help to write a function that would calcuate the fee column according
to the above table, the fee charged is based on their pattern of study, their
mode (O= overseas, E=home) and the student yr.

The pattern of study is made up of three terms, the student can study any
combination, i.e. Three terms fulltime (FFF), 2 terms part-time and 1term
fulltime (PFP, PPF etc.).

I have manually calculated the fee for you to confirm whether the function
is returning the correct answer.

Thanks.