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