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 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
