Formula help for Excel 97

[Nocturnica]

I need a formula help for Excel 97, yes, I know, it is an old version, but I
have Windows 95 and almost have enough money to get a new computer, and I
will be doing that within the next month or so, but I need this formula now,
he he

In cell I4 I need a formula that gives me the greater number of 2 cells
If H4 is greater than G4, then I need the number in H4 to show up in I4
If H4 is blank, then I need the number in G4 to show up in I4

Example:
G4 H4 I4
5 7 7
12 12

Any ideas on the formula for this?

Thanks,
Nocturnica

 

[T. Valko]

Try this:

=IF(COUNT(G4:H4),MAX(G4:H4),"")

Copy down as needed

 

[Nocturnica]

That did not do it, any other ideas?

Try this:

=IF(COUNT(G4:H4),MAX(G4:H4),"")

Copy down as needed

 

[Nocturnica]

Oh! It did work, I typed it in the wrong cell, duh!
Thank you so much, I have been working on that for days!!!

Hugs,
Nocturnica

 

[T. Valko]

You're welcome. Thanks for the feedback!

Next time, don't wait so long to ask for help.

 

[Nocturnica]

I did not even know about this site. I called Microsoft, and the guy gave me
the url because they can not help me because of it being Excel 97. But this
is a great site! And i use and get stupped daily in Excel, he he

 

[T. Valko]

I did not even know about this site.

I didn't know about it either. One day many years ago I was just randomly
surfing not looking for anything in particular and ended up here. I've been
here ever since!