Question: Page Layout Form Data Rev View Help D E F G A B 1 Miles Driven Mileage Cost 110 H 000 UN 6 7 8

 Page Layout Form Data Rev View Help D E F G

Page Layout Form Data Rev View Help D E F G A B 1 Miles Driven Mileage Cost 110 H 000 UN 6 7 8 9 10 11 12 13 14 15 16 17 18 Instructions We need to add an IF Function to cell B1 that calculates milage costs using the following rules: 1) First 100 miles driven should be calculated at $1.20 per mile 2) Any miles driven after 100 should be calculated at $0.90 per mile The soloution should adapt to changes made to the number of miles driven O

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!