Digit problem

  • Thread starter Thread starter Niek Otten
  • Start date Start date
N

Niek Otten

=IF(A1<B1,A1+10000-B1,A1-B1)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
I am trying to write a spreed sheet for electricty meter readings. The
problem I have is that the readings are set by the nunber of dials of the
meters,which clock over and start at 0 again.When you subtract the one
reading from the other eg (9999-45) no correct result.
Is there a way of setting number of digits?
 

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

Back
Top