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

Formula help for Excel 97
 

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

Formula help for Excel 97
 

That did not do it, any other ideas?

"T. Valko" wrote:

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

Formula help for Excel 97
 

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" wrote:

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

Formula help for Excel 97
 

You're welcome. Thanks for the feedback!

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

--
Biff
Microsoft Excel MVP


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

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

Formula help for Excel 97
 

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" wrote:

You're welcome. Thanks for the feedback!

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

--
Biff
Microsoft Excel MVP


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

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

Formula help for Excel 97
 

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!

--
Biff
Microsoft Excel MVP


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

You're welcome. Thanks for the feedback!

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

--
Biff
Microsoft Excel MVP


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

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