Forum Discussion
Simple division formula
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...
Hi Riny, it seems to think that I don't want a formula and recommend putting apostrophes before. But I do in fact want a formula. As I said, when I use a whole number it works fine, but as soon as I input a fraction using as shown above it says "There is a problem with this formula. Not trying to type a formula.......etc
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.