formulas

H

helpme

Why would there be zero's placed in a formula? Such as =(((I133-0)/17.5)*15)+0

I am learing formula's and I can't seem to find out why the zero's have been placed in there.
 
D

David McRitchie

Perhaps there was a problem with some cells that looked like they
were numbers but were text. One fixup was to select a cell with zero
in it, copy it, and then edit, paste special, add

causing =((I133-0)/17.5)*15
to become =(((I133-0)/17.5)*15)+0

it would be better to choose an empty cell instead and then
edit, paste special, add
--
 
J

Jonathan Rynd

Why would there be zero's placed in a formula? Such as
=(((I133-0)/17.5)*15)+0

Did you write this formula or did someone else? Where did the formula come
from?

If someone else wrote the formula, you'd have to ask them why they put
zeroes in there.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top