Mar 09 2019 05:26 PM
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 above 1500 charge at a separate rate can someone please provide some ideas on how to create those formulas
Mar 09 2019 06:08 PM
Mar 10 2019 01:57 AM
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
Mar 10 2019 04:54 AM