N
nasir ahmad
i have a worksheet of daily fee collection with this formula check on classess
=IF(E5="Play Group",3940, IF(E5="Nursery",3980, IF(E5="Kindergarten",4020)))
(where as 3940,3980 and 4020 is fee)
i want to calculate the late fee amount of 15 per day after each a specific due date like 15/04/08.
late fee is fixed i.e. 15 which will increase per day like 15 for 16/04/08 and onwords
like on 16/04/08 3940 become 3955
how i can use IF formula with dates. like if date is > greater than 15 of each month plus 15 with normal ammount.
help is required on urgent basis.
=IF(E5="Play Group",3940, IF(E5="Nursery",3980, IF(E5="Kindergarten",4020)))
(where as 3940,3980 and 4020 is fee)
i want to calculate the late fee amount of 15 per day after each a specific due date like 15/04/08.
late fee is fixed i.e. 15 which will increase per day like 15 for 16/04/08 and onwords
like on 16/04/08 3940 become 3955
how i can use IF formula with dates. like if date is > greater than 15 of each month plus 15 with normal ammount.
help is required on urgent basis.