Jan 25 2023 06:28 PM
So im pretty new and quite stumped.
so here in the Top Sales column I need and IF function to determine which two locations had the highest sales. this seems like it should be fairly easy but I've exhausted myself trying to figure it out.
this is for school and instructions state that the H column needs an IF statement.
like i can go through each cell and just give it a specific IF function but i feel like that is too easy. i assume there is a better more intuitive way but i cant find it. any help appreciated.
Jan 25 2023 06:48 PM
Jan 25 2023 06:57 PM
Jan 25 2023 07:12 PM
Jan 25 2023 07:39 PM
Jan 26 2023 12:56 PM
@Shiming thank you ill try this, and yea i noticed the average column was off.
Jan 26 2023 01:11 PM
I suspect the instructor is looking for something simple:
=IF(OR(G2=MAX($G$2:$G$8),G2=LARGE($G$2:$G$8,2)),"Top","")