(big beginner over here) how to reference vertically arranged cells horizontally for an IF function
I'm very new to excel and doing a example data work sheet, this problems a little trick to explain, at least for me it is. I have a column of numbers that represent the discount a seller gave through bargaining, the numbers are from J2-J13 and I'm trying to make a if formula or function or whatever to see if they met the discount average, but the numbers are displayed vertically, and I want to display the if function and copy and paste it diagonally(B20-M20) because I think it would look better and fit what I'm trying to do. I've tried looking it up on Google, and asking Gemini for help and this was my last resort. Any crucial tips for beginners would be appreciated too.
YES, I know this is very simple baby work I'm new, this is my second time doing a practice thing like this, any tips would be greatly appreciated.
[link] [comments]
Want to read more?
Check out the full article on the original site