Related:
- Excel formula - sumproduct
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Credit summation 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 :)