Forum Discussion

Stillgrinning's avatar
Stillgrinning
Copper Contributor
Feb 12, 2022
Solved

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  ...
Excel on Mac
  • SergeiBaklan's avatar
    SergeiBaklan
    Feb 12, 2022

    Stillgrinning 

    Perhaps

    =IF( SUM(G2, G5*0.2068) = 0, "", SUM(G2, G5*0.2068) )
NikolinoDE's avatar
NikolinoDE
Gold Contributor
Feb 12, 2022

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.

Stillgrinning's avatar
Stillgrinning
Copper Contributor
Feb 14, 2022

NikolinoDE Still getting the #VALUE

 

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

Cheers Chris

 

Resources