<= > in a formula
Closed
Moe

Feb 24, 2010 at 04:51 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022  Feb 24, 2010 at 05:01 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022  Feb 24, 2010 at 05:01 PM
Related:
 <= > in a formula
 Date formula in excel dd/mm/yyyy  Guide
 Number to words in excel formula  Guide
 Logitech formula vibration feedback wheel driver  Download  Drivers
 Excel grade formula  Guide
 Cardtext formula in word  Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 24, 2010 at 05:01 PM
Feb 24, 2010 at 05:01 PM
Use if statement
Lets say mileage is in cell A1 and cost needs to be in B1, then in B1 you can write
=IF(A1="","",IF(A1<=100,A1*1.2,(100*1.2)+(A1100)*0.9))
Lets say mileage is in cell A1 and cost needs to be in B1, then in B1 you can write
=IF(A1="","",IF(A1<=100,A1*1.2,(100*1.2)+(A1100)*0.9))