1 min readfrom 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?

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

Want to read more?

Check out the full article on the original site

View original article