In cell J6, enter a formula to determine the total cost with gas if the customer chose that option as indicated in column I. Use the name range for cell B44 in this formula.

I tried the formula=IF(I6="n",H6,IF(I6="y",(H6*GasCost))). But when it gets to an answer with y i end up with ####

Express Car Rental Rentals Initiated in Week Starting 4/5/2015 Created by Jason Easton Auto Type Green Collection Compact/Midsize Compact/Midsize Green Collection Fullsize/Standard SUV/Minivan SUV/Minivan Fullsize/Standard Green Collection Compact/Midsize Fullsize/Standard Fullsize/Standard Fullsize/Standard SUV/Minivan SUV/Minivan Green Collection Green Collection Green Collection Fullsize/Standard SUV/Minivan SUV/Minivan Fullsize/Standard Fullsize/Standard Compact/Midsize Compact/Midsize SUV/Minivan Green Collection Auto Id Date Rented 988 4/5/2015 275 4/5/2015 277 4/9/2015 990 4/5/2015 350 4/5/2015 550 4/5/2015 551 4/7/2015 352 4/7/2015 989 4/6/2015 275 4/11/2015 355 4/9/2015 356 4/6/2015 350 4/9/2015 553 4/8/2015 550 4/11/2015 988 4/9/2015 989 4/10/2015 990 4/7/2015 356 4/9/2015 551 4/11/2015 554 4/7/2015 352 4/10/2015 356 4/11/2015 276 4/11/2015 277 4/11/2015 554 4/10/2015 990 4/11/2015 Rental Rates Green Collection Compact/Midsize Fullsize/Standard SUV/Minivan $49.99 $76.49 $84.99 $104.99 Discount for Express Miles or Rewards Cost to Fill Tank 20% $65.00 Date Returned/or Expected Return #Days Rented 4/8/2015 3 4/10/2015 5 4/10/2015 1 4/6/2015 1 4/8/2015 3 4/9/2015 4 4/10/2015 3 4/9/2015 2 4/9/2015 3 4/18/2015 7 4/16/2015 7 4/8/2015 2 4/13/2015 4 4/14/2015 6 4/17/2015 6 4/15/2015 6 4/16/2015 6 4/10/2015 3 4/10/2015 1 4/15/2015 4 4/9/2015 2 4/11/2015 1 4/17/2015 6 4/14/2015 3 4/15/2015 4 4/12/2015 2 4/18/2015 7 Payment Method Credit Card COD Express Miles Credit Card Credit Card Rewards Credit Card Credit Card Credit Card COD Credit Card Credit Card Rewards Express Miles COD Credit Card Express Miles Credit Card Rewards Express Miles Express Miles Credit Card Express Miles Credit Card Rewards COD Express Miles Median Rental Length Number of Rentals /2015 Daily Rate $49.99 $76.49 $76.49 $49.99 $84.99 $104.99 $104.99 $84.99 $49.99 $76.49 $84.99 $84.99 $84.99 $104.99 $104.99 $49.99 $49.99 $49.99 $84.99 $104.99 $104.99 $84.99 $84.99 $76.49 $76.49 $104.99 $49.99 Total before Options Gas Option n n n n y y n y n n y y y y y n n n n y y y y n n y n Total