Feb 12 2022 05:03 AM
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.
Feb 12 2022 05:41 AM
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.
I know I don't know anything (Socrates)
Feb 12 2022 05:53 AM
You could change the formula in D5 to =IF(D3=0,"",D3-C3) and fill to the right.
Feb 12 2022 05:58 AM
@NikolinoDE Thanks, You say Example in E5 where am I looking at? Sorry to be so vague. Very New to Excel.
Thanks again
Feb 12 2022 06:27 AM
examble in file
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
Feb 12 2022 08:47 AM
@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
Feb 12 2022 09:58 AM
@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
Feb 12 2022 10:14 AM
SolutionFeb 12 2022 10:24 AM
#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.
I know I don't know anything (Socrates)
Was the answer useful? Mark them as helpful!
This will help all forum participants.
Feb 14 2022 03:48 AM
Feb 14 2022 04:26 AM
Feb 14 2022 09:00 AM
Feb 14 2022 10:06 AM
should actually work...if I didn't make a mistake in reasoning :).
Have fun with Excel.
Feb 14 2022 10:50 AM
Feb 12 2022 10:14 AM
SolutionPerhaps
=IF( SUM(G2, G5*0.2068) = 0, "", SUM(G2, G5*0.2068) )