Forum Discussion
Sparky16
Mar 10, 2019Copper Contributor
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 ...
Twifoo
Mar 10, 2019Silver Contributor
Perhaps, you need a formula like this:
=IF(A1>1500,
A1*25,
A1*20)
=IF(A1>1500,
A1*25,
A1*20)