Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
160
Views
Topic starter
How to do the below requirement formula.
E.g.: from 1 May to 5 May , every day meal allowance is $35 per day. Total is $140(4*35).
But in between got one day have business meal, the meal allowance will be half of the meal allowance. Example 3 May have a business meal.
So the total meal allowance is 122.5(140-17.5)
How to do this formula?
Posted : 23/05/2017 10:22 am
Hi,
I'm not sure I have enough information to give you the formula I think you are after. Isn't the formula simply 3.5 * $35 ?
Are you after something like this:
(Number of Normal Days + 0.5*Number of Business Days) * $35
regards
Phil
Posted : 24/05/2017 10:27 pm
