i am trying to do a spreadsheet using sales – G10-14 have the profit in them, i need to then do a bonus column (K) – I need to do an IF formula selecting the highest profit and show they get a $2000 bonus. this is really getting me stuck!! I have attached my Spreadsheet Just the one page, then the summary solution which is how its meant to look - i just cant match it.
this is the question - - Use an IF Function to display $2,000 for the store with the Highest Gross Profit
Hi Nicole, I had a look at your spreadsheet. If I understand your question what you want is a bonus of 2000 for the highest profit - which is 19590 (G14). Am attaching a sheet with a formula in column K. See if that works for you. A
You are amazing 🙂 Thankyou, everytime i did it i got an error!!
No problem. Happy to help. 🙂
