Sep 02 2022 01:27 AM
I am having a problem with a simple formula I use all the time. When I try and divide a number or cell by a fraction eg. =SUM(a2/0.8) it gives an error, however if I divide by a whole number it works fine
Sep 02 2022 01:32 AM - edited Sep 02 2022 01:32 AM
@Chris1961 What error? #DIV/0!, by any chance? If so, change the decimal point to a comma. By the way, you don't need SUM.
Sep 02 2022 01:55 AM
Sep 02 2022 01:58 AM
Sep 02 2022 02:01 AM - edited Sep 02 2022 02:02 AM
@Chris1961 That's odd. Can you include a screenshot similar to what I did below?
And please check the attached file that has the formula exactly as you wrote it.
Edit: Hadn't seen your latest message confirming it was the comma.