In cell B11, use the IF function to test if the expense is tax deductible using cell J4. If it is, just return the value in cell K4. If it isnt, use a formula to return the total value of the expense and its tax (the tax rate is in cell L3). Autofill your formula through cell range B12:B16.

Autober 1 2 Auto Racebu - Cameron MacDonald CM Fle Home Insert Page Layout Formulas Reye View Help Share Gues.) > Autobum BLU X Cut In Copy Parte Format Paimer 27 Trebuchet MS BIU.L. 2 WITH == DO Mayen Normal Conditional Format we Calculation Formatting Table Rad Good Neutral Check Coll Explanato Explanato... Input nsert Delete commal Ideas S - %23 >> Clear Sort & Find & Filter Select Sensitivity Cipod Fun Ali Mumbai Cel Editing Ideas Sms 011 B C D E F G H ! L M N 0 P 0 R 5 1 U v 1 Racing Profitability 2 3 Total Revenue 1250000 5 6 Tax Rate (averaged) 12% 4 Revenue Amount Winner's Purse 1000000 Sponsorships 250000 Expenses Tax Deductibic Auto INO Auto Deprecation Yes Fur! Yes Parts Yes Repairs No Transportation lyes Amount 120000 24000 900 10000 10000 750 7 8 9 10 Total Expenses 11 Auto 12 Auto Depreciation 13 rue 14 Parts 15 Repairs 16 Transportation 17 Total 18 19 20 Total Profit/Loss 21 ZZ 23 24 25 26 27 28 29 30 31 32 33 34 36 37 Racing Profitability Race Results Ready Display Settings