Friday, July 7, 2017

yogi_Multi_Criteria Row By Row LookUp And Computation

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?


***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