Forum Discussion
Boyneelec
Aug 11, 2022Copper Contributor
Excel formula help
Hi All, I am looking for some help in getting a formula right for the following scenario. Photo 1 contains a brief description of what I am trying to do, While photo 2 is a screen grab from "sheet4"...
- Aug 12, 2022
Do you use comma as decimal separator? If so, replace all commas in the formula with semicolons.
Boyneelec
Aug 12, 2022Copper Contributor
HansVogelaar I tried that in all the appropriate cells but keep getting an error as below
HansVogelaar
Aug 12, 2022MVP
Do you use comma as decimal separator? If so, replace all commas in the formula with semicolons.
- BoyneelecAug 12, 2022Copper ContributorHansVogelaar That worked a treat. Thank's a million