Enter a formula in cell B10 to return a value of 35000 if the Net Profit After Tax (cell B9) is greater than or equal to 470000 or 1000 if it is not. B 6. OwnersDraw - Excel File Home Insert Page Layout Formulas Data Review A Calibri 10 - A A View Tell me what you want to do... Et Wrap Text General Merge & Center $ - % T Em H * Cut Ee Copy Format Painter Paste BIU D-A- Y Insert Del +0.00 .000 = Y Conditional Format Cell Formatting as Table - Styles Styles Clipboard Font 15 Alignment 15 Number Ce B10 x for A B D E F G G H 1 j K L M N O $ 1 Sales 2 Cost/ Goods Sold (COGS) 3 Gross Profit 1,300,000 75,000 1,225,000 $ 4 $ 839,700 5 Operating Expenses 6 7 Net Profit Before Tax 8 Income Taxes 9 Net Profit After Tax 10 Owner Draw/ Dividends 11 385,300 57,795 327,505 12 13 14 15 1