Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |