SOLVED

# Excel Newbie

Occasional Contributor

# Excel Newbie

Hi Help needed, with the rising costs of Energy Bills, I am trying to keep a record of usage.

Low and behold I have come my first obstacle. I keep getting the meter reading coming up as a Negative  figure in the next column. The formula used is =D3-C3 then filled along. If I put in a new formula each week then all is OK. Will stick a picture below. (not the actual readings just testing)

Probably 1 of many questions.

Thanks for help in advance.

17 Replies

# Re: Excel Newbie

A quick and easy solution

=IF(E3=0,"",E3-D3)

Examble in E5

additional info:

Bill paying checklist Template

Hope I was able to help you with this info.

NikolinoDE

I know I don't know anything (Socrates)

# Re: Excel Newbie

You could change the formula in D5 to =IF(D3=0,"",D3-C3) and fill to the right.

# Re: Excel Newbie

@NikolinoDE Thanks, You say Example in E5 where am I looking at? Sorry to be so vague. Very New to Excel.

Thanks again

OK thanks

# Re: Excel Newbie

examble in file

Hope I was able to help you with this info.

NikolinoDE

I know I don't know anything (Socrates)

# Re: Excel Newbie

@NikolinoDE  Trying to get back to you but easier to upload a template file, but can't see how to attach a file, you managed it. I can't see how to.

Chris

# Re: Excel Newbie

@NikolinoDE Hi again, said it wouldn't be long before asking for help.

I have been playing. getting  #VALUE due to no data in the cel? Can this be corrected. I can add a picture to this chat but not a file.  Many thanks Chris

best response confirmed by Stillgrinning (Occasional Contributor)
Solution

# Re: Excel Newbie

Perhaps

``=IF( SUM(G2, G5*0.2068) = 0, "", SUM(G2, G5*0.2068) )``

# Re: Excel Newbie

#VALUE is Excel's way of saying, "There's something wrong with the way your formula is typed. Or, there's something wrong with the cells you are referencing." The error is very general, and it can be hard to find the exact cause of it. The information on this page shows common problems and solutions for the error. You may need to try one or more of the solutions to fix your particular error.

How to correct a #VALUE! error

You could also use SUM in the same fashion:

=SUM(IF(ISERROR(G7),"",(F5*0.2068+F2)))

...should work :).

Hope I was able to help you with this info.

NikolinoDE

I know I don't know anything (Socrates)

Was the answer useful? Mark them as helpful!

This will help all forum participants.

# Re: Excel Newbie

Many thanks. Will play with it tomorrow.

# Re: Excel Newbie

Thank you, Will play with this tomorrow.

# Re: Excel Newbie

@NikolinoDE Still getting the #VALUE

I think it may go on the back burner for  while.

Cheers Chris

# Re: Excel Newbie

Drag and drop here or browse files to attach
Maximum size: 71 MB • Maximum attachments allowed: 5

# Re: Excel Newbie

@Stillgrinning File uploaded

# Re: Excel Newbie

Have uploaded the file a bit lower down, but I think to myself. Gloom.

# Re: Excel Newbie

should actually work...if I didn't make a mistake in reasoning :).

Have fun with Excel.

# Re: Excel Newbie

That Appears to work, will carry on inserting more data. Many Thanks