Google Spreadsheet Post #2203
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jul-07-2017
question by O Ramirez:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/BJgy-4FOwCQ;context-place=forum/docs
Please help me figure out an IF formula for two ISSUES I am having!!!
Hi need help figuring out how to automate the Total & Fees columns every time we put the trip mileage?
Example 1 : D3 should be $25 because it is wheelchair trip but only One Way
***EXAMPLES FOR TOTALS
Example 1 : C2 should be $15 because it is ambulatory and it is equal or between 16 & 30 miles.
Example 2 : C6 should be $20 because it is wheelchair and it is equal or between 16 & 30 miles.
***EXAMPLES FOR FEES(only applicable to wheelchair)
Example 1 : D3 should be $25 because it is wheelchair trip but only One Way
Example 2 : D6 should be $50 because it is wheelchair trip and Round Trip
No comments:
Post a Comment