Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel Formula Doesn't Execute (Shows formula-not the calcuation) | Excel Discussion (Misc queries) | |||
match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions |