Vehicle furchase Assumptions IIHS Safety Rating Lookup Chart J= Craniofacial = Rotator CUff (DASH) Total knec (2kFS) Total Shaider \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ Key } \\ \hline S= & Good \\ \hline S= & Acceptabie \\ \hlineM= & Marginal \\ \hlineP= & Poor \\ \hline \end{tabular} 14. Determine which trucks are affordable. a. Using absolute cell referencing as appropriate. in cell C32, enter a formula using an If function to determine if the total monthly cost is less than or equal to the total monthly cost amount available for vehicle expenses. The total monthly cost is located in cell C30 on the Purchose worksheet. The total monthly cost amount available forvehicle expenses is located in cell A4 on the Dato worksheet. If the total monthly cost is not less than or equal to the total monthly amount available, display "no", if it is display "yes". b. Copy the formula to the appropriate cells for the other trucks. c. Display formulas and use the error checking skills learned in this lesson to track down and fix any errors