Related:
- Excel formula - sumproduct
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Transfer data from one excel worksheet to another automatically formula - Guide
1 response
Upon closer inspection it occured to me that the actual problem is that the formula's weren't automatically updating when the reference cell E2 was changed. I did a quick look online for the source of that issue and found it's under Tools-Options-Calculations and yep sure enough for some silly reason it was set to Manual! Changed it to automatic and hey presto! Cells formulas update properly so the original formula was right after all. Problem solved. Sorry for jumping the gun. Will check things more thoroughly next time (will probably help if I don't have a head cold to contend with as well!). Thanks anyways :)