Question: How would I write the nested IF function for this problem? For Excel please The Transportation Costs As a part of their financial report, Selina
The Transportation Costs As a part of their financial report, Selina and Bruce calculated the expected transportation costs. After discussion, they found complex criteria for the transportation costs If the time to school on foot is lower than 45 mins, they will commute to school on foot. It will cost $0. 2. If the time to school on foot is higher than or equal to 45 mins, and the time to school by public transportation is lower than 90, they will commute to school by the public transportation. It will cost $120 for two people, If the time to school on foot is higher than or equal to 45 mins, and the time to school by public transportation is higher than or equal to 90, they will commute to school by car.it will cost $600 per a month for two people. To Calculate the formula for the transportation cost, you must use a nested if function. Please use the PDF tutorials in MyCourses or click on the following link
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
