Wednesday, April 17, 2013

yogi_Compute Transaction Value Depending On Whether F4 Houses Finance Warranty Or Gap


                                          Google Spreadsheet   Post  #1139
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 17, 2013
user HaleyToyotaOfRoanoke :(http://productforums.google.com/forum/?zx=fdisqnjyvx1n#!category-topic/docs/spreadsheets/aj-S6hJRwyU)
Help with Text Strings, resulting in addition to sum


                      A                    B             C          D            E                        F                               G                       H                     I                       J                    K

Row 1           Time        stock # name     Units New/Used?           Finance?          Gross on Deal   Comm Gross   Comm Draft Comm Draft2 Commission

Row 4         4/5/2013        R01254 Krisha 1 New Car   Finance, Warranty, Gap      $948.72      $658.54      $197.56      $197.56   #ERROR!


Here's what I have now

=IF(FIND("Finance,"E4;J4+25);IF(F4="Warranty";J4+25;IF(F4="Gap";J4+15)))

I am trying to get K4 to look and see if F4 has "Finance," "Warranty," or "Gap" in it. If Finance, J4+25. If Warranty, J4+25. If Gap, J4+15.

So, in this instance I need K4 to read out: $262.56
---------------------------------------------------------------------------------------------------------------------------------

have a look at the solution I have presented in the following