Notifications
Clear all
Topic starter
Hello everyone
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. Attached is my Spreadsheet with the summary solution example
Thanks.
Posted : 03/10/2018 2:59 am
There is no attachment.
You can try this. In cell K10 enter
=IF(G10=MAX($G$10:$G$14),2000,0)
copy till K14
Hope this helps.
Sunny
Posted : 03/10/2018 3:17 am
