Try this:

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

Copy down as needed

--
Biff
Microsoft Excel MVP


"Nocturnica" wrote in message
...
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