Mahfuzah90
New Member
- Joined
- Oct 12, 2016
- Messages
- 3
Hello guys, can anyone help me to create a formula for 2 situation as below:
SITUATION 1
KM = Kilometres
RM = currency
Total KM = 943KM (Assumption Cell = A2) , Total Cost = RM??
<tbody>
</tbody>
Formula i used in excel:
=A2*0.65+MIN(A2,500)*0.05
=RM637.95
*it's correct formula???,
SITUATION 2
KM = Kilometres
RM = currency
Total KM = 943KM (Assumption Cell = A2), Total Cost = RM??
<tbody>
</tbody>
Or if you have other formula that more easier than this? kindly share with me.
Thank you in advance.
SITUATION 1
KM = Kilometres
RM = currency
Total KM = 943KM (Assumption Cell = A2) , Total Cost = RM??
First 500KM | X RM0.70 |
Next 500KM | X RM0.65 |
<tbody>
</tbody>
Formula i used in excel:
=A2*0.65+MIN(A2,500)*0.05
=RM637.95
*it's correct formula???,
SITUATION 2
KM = Kilometres
RM = currency
Total KM = 943KM (Assumption Cell = A2), Total Cost = RM??
First 50 KM | RM150.00 |
Next 200KM | x RM3.00 |
Next 250KM | x RM2.25 |
Next 250KM | x RM1.50 |
Next 250KM | x RM1.13 |
Next 250KM | x RM0.75 |
<tbody>
</tbody>
Or if you have other formula that more easier than this? kindly share with me.
Thank you in advance.