February 4, 2026•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Which formulas to avoid for intermediate users (5 years experience)?

I am creating a forecasting model for a large client within FMCG. I am a consultant and will be leaving in about 2 months (if they don't prolong).

My question is - what formulas should I avoid so people can understand my file?

This is my list so far of formulas to avoid:

- Nested Ifs

- Sumproduct

- Indirect

Am I missing anything obvious that should be on the no-no list for intermediate users?

Check out the full article on the original site

#Excel alternatives for data analysis

#natural language processing for spreadsheets

#generative AI for data analysis

#rows.com

#Excel compatibility

#large dataset processing

#Nested Ifs

#Sumproduct

#Indirect

#formulas to avoid

#intermediate users

#forecasting model

#FMCG

#consultant

#Excel

#client

#modeling

#consulting

#no-no list

#understand