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...
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.
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