If/then worked 2 weeks ago but now ...??

[GeorgiaGal]

Is anyone an Excel worksheet Macro user?
I'm having difficulty with a macro formula working and now it doesn't.
i.e. Examples:

In F3451: =SUM(F3402:F3450) (Will always be NEGATIVE)
In G3451: =SUM(G3402:G3450) (Will always be POSITIVE)
In H3451: =F3451+G3451 (Should always be NEGATIVE)
The above are computing correctly.

In H3453: _____________ (I manually enter a POSITIVE figure)
In I3453: =NOW() (formatted mm/dd/yyyy)

In H3454: =H3451+H3453 (Ideally should be zero)
In I3454: =IF((F3451+G3451+H3453=0),"Good","Whoops")

H3451 is the sum of a column of negative numerics.
H3453 is the sum of a column of positive numerics.

The dilemma: Up until several weeks ago, I3454 would result in Good or Whoops.
If the resulting expression became Whoops, I would research and correct to receive the Good response.

Otherwise, response is Good, then All is A-Okay and desirable.

NOW The Dilemma/Issue: The result is always Whoops even when I manually see it should be Good. It's ***as though*** it's not recognizing the computation but rather the formula (which is written in alpha/numerics.)

 

[6StringJazzer]

What are the values displayed in cells F3451, G3451, H3453 that cause I3454 to show "Whoops" even though you think it should show "Good"?

If I walk back your formula in I3454:
=IF((F3451+G3451+H3453=0),"Good","Whoops")
F3451 references F3402:F3450
G3451 references G3402:G3450
H3453 is a value, manually entered

You also mention I3453, H3454, H3451 but they appear to be irrelevant to this formula.