SOLVED

Excel Newbie

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3157368%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EExcel%20Newbie%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3157368%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHi%20Help%20needed%2C%20with%20the%20rising%20costs%20of%20Energy%20Bills%2C%20I%20am%20trying%20to%20keep%20a%20record%20of%20usage.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3ELow%20and%20behold%20I%20have%20come%20my%20first%20obstacle.%20I%20keep%20getting%20the%20meter%20reading%20coming%20up%20as%20a%20Negative%20%26nbsp%3Bfigure%20in%20the%20next%20column.%20The%20formula%20used%20is%26nbsp%3B%3DD3-C3%20then%20filled%20along.%20If%20I%20put%20in%20a%20new%20formula%20each%20week%20then%20all%20is%20OK.%20Will%20stick%20a%20picture%20below.%20(not%20the%20actual%20readings%20just%20testing)%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EProbably%201%20of%20many%20questions.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThanks%20for%20help%20in%20advance.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-right%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F347491iBF8371AF66E453A9%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Excel01.jpg%22%20alt%3D%22%5C%26quot%3BExcel01.jpg%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3157368%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Contributor

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.

Excel01.jpg

17 Replies

@Stillgrinning 

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)

@Stillgrinning 

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

@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

@Stillgrinning 

examble in file

 

Hope I was able to help you with this info.

NikolinoDE

I know I don't know anything (Socrates)

@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

@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

Screenshot 2022-02-12 at 17.52.03.png

best response confirmed by Stillgrinning (Occasional Contributor)
Solution

@Stillgrinning 

Perhaps

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

@Stillgrinning 

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

Many thanks. Will play with it tomorrow.
Thank you, Will play with this tomorrow.

@NikolinoDE Still getting the #VALUE

 

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

Cheers Chris

 

Screenshot 2022-02-14 at 11.44.20.png

@Stillgrinning 

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

@Stillgrinning File uploaded

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

@Stillgrinning 

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

 

Have fun with Excel.

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