View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nocturnica Nocturnica is offline
external usenet poster
 
Posts: 8
Default Formula help for Excel 97

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