1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

(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.

submitted by /u/repeatoffeder9000
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#Excel compatibility
#real-time data collaboration
#Excel alternatives
#big data management in spreadsheets
#rows.com
#big data performance
#AI formula generation techniques
#conversational data analysis
#google sheets
#intelligent data visualization
#real-time collaboration
#data visualization tools
#formula generator
#enterprise data management
#data analysis tools
#data cleaning solutions
#Excel