Forum Discussion
Formula in Excel
I know the basics in creating some formulas I'm trying to create a spread sheet for mileage that if someone has up to 1500km it is charged at a specific rate , and in another column I want anything ...
For the data structured like this
if in B1 is your rate for the mileage below 1500, and in C1 - above it, you may use formulas
in B2: =MIN($A2,1500)*$B$1 in C2: =MAX(0,$A2-1500)*$C$1 in D2: =B2+C2
and drag them down till end of your range