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
Used the comma and it seems to work, sure I used decimal point before but maybe I'm more forgetful than I thought. Thanks for the suggestion