If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
Insert Cell Name of a value that matches a MAX function
If the cell that it is pointing to is null or blank
Then leave the cell that it is be inserted blank not with zeros or #NA. The format in the cell it is pointing to, is a date field. Thanks -----Original Message----- Hi you may explain what you're trying to achieve with this new formula: - check if the cell is empty - check if the cell conatins an error - check if the cell is zero -- Regards Frank Kabel Frankfurt, Germany A Rios wrote: Thanks for the help, bit it did not work The function I use below displays a values of 0 (Zero) when nothing is in that field. =Project!C5 (if this field is blank it displays a zero). I could use the tools option to not display zeros but if we want to add other numerical fields and display zeros then it's not feasible. Can you help..This is the last request.. We ( My Son and I ) greatly appreciate the support. -----Original Message----- Hi this works only if cell D10 conatins a #NA error. If you want to check for any error try =if(ISERROR(Project!D10)),"". -- Regards Frank Kabel Frankfurt, Germany Al Rios wrote: Just typed it in and it works fantastic. I tried to use the same concept for anther field but no luck. Can you help =if(ISNA(Project!D10)),"". You guys are great.... -----Original Message----- Hi Al, I just tried the formula and it works fine. However, I did get the error when I first copied/pasted it into my worksheet. I think hard returns seemed to have been the problem, probably due to copying/pasting. You'll find that if you type it in, you won't have a problem. Hope this helps! In article 15a9e01c4470f$3c225120 , "Al Rios" wrote: Get an Error, It states the "Formula You enter contains an Error" This is what I have: E1 thru H1 are text Values from the header E2 thru H2 are date values.. Above may help.. Thanks very much.. . . . |
#22
|
|||
|
|||
Insert Cell Name of a value that matches a MAX function
Hi
use Peo's suggestion then: =IF(Project!D10="","",Project!D10) -- Regards Frank Kabel Frankfurt, Germany Al Rios wrote: If the cell that it is pointing to is null or blank Then leave the cell that it is be inserted blank not with zeros or #NA. The format in the cell it is pointing to, is a date field. Thanks -----Original Message----- Hi you may explain what you're trying to achieve with this new formula: - check if the cell is empty - check if the cell conatins an error - check if the cell is zero -- Regards Frank Kabel Frankfurt, Germany A Rios wrote: Thanks for the help, bit it did not work The function I use below displays a values of 0 (Zero) when nothing is in that field. =Project!C5 (if this field is blank it displays a zero). I could use the tools option to not display zeros but if we want to add other numerical fields and display zeros then it's not feasible. Can you help..This is the last request.. We ( My Son and I ) greatly appreciate the support. -----Original Message----- Hi this works only if cell D10 conatins a #NA error. If you want to check for any error try =if(ISERROR(Project!D10)),"". -- Regards Frank Kabel Frankfurt, Germany Al Rios wrote: Just typed it in and it works fantastic. I tried to use the same concept for anther field but no luck. Can you help =if(ISNA(Project!D10)),"". You guys are great.... -----Original Message----- Hi Al, I just tried the formula and it works fine. However, I did get the error when I first copied/pasted it into my worksheet. I think hard returns seemed to have been the problem, probably due to copying/pasting. You'll find that if you type it in, you won't have a problem. Hope this helps! In article 15a9e01c4470f$3c225120 , "Al Rios" wrote: Get an Error, It states the "Formula You enter contains an Error" This is what I have: E1 thru H1 are text Values from the header E2 thru H2 are date values.. Above may help.. Thanks very much.. . . . |
#23
|
|||
|
|||
Insert Cell Name of a value that matches a MAX function
Works Great,,
one more item I forgot I want to do the same for the below format =MAX(Project!E2:H2) All of you guys are great...You don't know how much my son is understanding the importance of education. I really...really aprreciate it this. Makes Memorial Day a day to remember,,especially me..a vet for 24 years.. Thank God to all of you.. -----Original Message----- Try =IF(Project!C5="","",Project!C5) -- For everyone's benefit keep the discussion in the newsgroup. Regards, Peo Sjoblom "A Rios" wrote in message ... Thanks for the help, bit it did not work The function I use below displays a values of 0 (Zero) when nothing is in that field. =Project!C5 (if this field is blank it displays a zero). I could use the tools option to not display zeros but if we want to add other numerical fields and display zeros then it's not feasible. Can you help..This is the last request.. We ( My Son and I ) greatly appreciate the support. -----Original Message----- Hi this works only if cell D10 conatins a #NA error. If you want to check for any error try =if(ISERROR(Project!D10)),"". -- Regards Frank Kabel Frankfurt, Germany Al Rios wrote: Just typed it in and it works fantastic. I tried to use the same concept for anther field but no luck. Can you help =if(ISNA(Project!D10)),"". You guys are great.... -----Original Message----- Hi Al, I just tried the formula and it works fine. However, I did get the error when I first copied/pasted it into my worksheet. I think hard returns seemed to have been the problem, probably due to copying/pasting. You'll find that if you type it in, you won't have a problem. Hope this helps! In article 15a9e01c4470f$3c225120 , "Al Rios" wrote: Get an Error, It states the "Formula You enter contains an Error" This is what I have: E1 thru H1 are text Values from the header E2 thru H2 are date values.. Above may help.. Thanks very much.. . . . |
#24
|
|||
|
|||
Insert Cell Name of a value that matches a MAX function
Works Great,, one more item I forgot I want to do the same for the below format =MAX(Project!E2:H2) All of you guys are great...You don't know how much my son is understanding the importance of education. I really...really aprreciate this. Makes Memorial Day a day to remember,,especially me..a vet for 24 years.. Thank God to all of you.. -----Original Message----- Try =IF(Project!C5="","",Project!C5) -- For everyone's benefit keep the discussion in the newsgroup. Regards, Peo Sjoblom "A Rios" wrote in message ... Thanks for the help, bit it did not work The function I use below displays a values of 0 (Zero) when nothing is in that field. =Project!C5 (if this field is blank it displays a zero). I could use the tools option to not display zeros but if we want to add other numerical fields and display zeros then it's not feasible. Can you help..This is the last request.. We ( My Son and I ) greatly appreciate the support. -----Original Message----- Hi use Peo's suggestion then: =IF(Project!D10="","",Project!D10) -- Regards Frank Kabel Frankfurt, Germany Al Rios wrote: If the cell that it is pointing to is null or blank Then leave the cell that it is be inserted blank not with zeros or #NA. The format in the cell it is pointing to, is a date field. Thanks -----Original Message----- Hi you may explain what you're trying to achieve with this new formula: - check if the cell is empty - check if the cell conatins an error - check if the cell is zero -- Regards Frank Kabel Frankfurt, Germany A Rios wrote: Thanks for the help, bit it did not work The function I use below displays a values of 0 (Zero) when nothing is in that field. =Project!C5 (if this field is blank it displays a zero). I could use the tools option to not display zeros but if we want to add other numerical fields and display zeros then it's not feasible. Can you help..This is the last request.. We ( My Son and I ) greatly appreciate the support. -----Original Message----- Hi this works only if cell D10 conatins a #NA error. If you want to check for any error try =if(ISERROR(Project!D10)),"". -- Regards Frank Kabel Frankfurt, Germany Al Rios wrote: Just typed it in and it works fantastic. I tried to use the same concept for anther field but no luck. Can you help =if(ISNA(Project!D10)),"". You guys are great.... -----Original Message----- Hi Al, I just tried the formula and it works fine. However, I did get the error when I first copied/pasted it into my worksheet. I think hard returns seemed to have been the problem, probably due to copying/pasting. You'll find that if you type it in, you won't have a problem. Hope this helps! In article 15a9e01c4470f$3c225120 , "Al Rios" wrote: Get an Error, It states the "Formula You enter contains an Error" This is what I have: E1 thru H1 are text Values from the header E2 thru H2 are date values.. Above may help.. Thanks very much.. . . . . |
#25
|
|||
|
|||
Insert Cell Name of a value that matches a MAX function
Hi
for the MAX function you don't have to check for blank cells. Excel will omitt them automatically -- Regards Frank Kabel Frankfurt, Germany Al Rios wrote: Works Great,, one more item I forgot I want to do the same for the below format =MAX(Project!E2:H2) All of you guys are great...You don't know how much my son is understanding the importance of education. I really...really aprreciate it this. Makes Memorial Day a day to remember,,especially me..a vet for 24 years.. Thank God to all of you.. -----Original Message----- Try =IF(Project!C5="","",Project!C5) -- For everyone's benefit keep the discussion in the newsgroup. Regards, Peo Sjoblom "A Rios" wrote in message ... Thanks for the help, bit it did not work The function I use below displays a values of 0 (Zero) when nothing is in that field. =Project!C5 (if this field is blank it displays a zero). I could use the tools option to not display zeros but if we want to add other numerical fields and display zeros then it's not feasible. Can you help..This is the last request.. We ( My Son and I ) greatly appreciate the support. -----Original Message----- Hi this works only if cell D10 conatins a #NA error. If you want to check for any error try =if(ISERROR(Project!D10)),"". -- Regards Frank Kabel Frankfurt, Germany Al Rios wrote: Just typed it in and it works fantastic. I tried to use the same concept for anther field but no luck. Can you help =if(ISNA(Project!D10)),"". You guys are great.... -----Original Message----- Hi Al, I just tried the formula and it works fine. However, I did get the error when I first copied/pasted it into my worksheet. I think hard returns seemed to have been the problem, probably due to copying/pasting. You'll find that if you type it in, you won't have a problem. Hope this helps! In article 15a9e01c4470f$3c225120 , "Al Rios" wrote: Get an Error, It states the "Formula You enter contains an Error" This is what I have: E1 thru H1 are text Values from the header E2 thru H2 are date values.. Above may help.. Thanks very much.. . . . |
#26
|
|||
|
|||
Insert Cell Name of a value that matches a MAX function
The cell that the value is inserting is formated as a
date field and I get these values when the cell I point to is blank and inserts it in the cell I want to. 01/00/00 01/00/00 01/00/00 01/00/00 01/00/00 01/00/00 01/00/00 01/00/00 01/00/00 01/00/00 Thanks -----Original Message----- Hi for the MAX function you don't have to check for blank cells. Excel will omitt them automatically -- Regards Frank Kabel Frankfurt, Germany Al Rios wrote: Works Great,, one more item I forgot I want to do the same for the below format =MAX(Project!E2:H2) All of you guys are great...You don't know how much my son is understanding the importance of education. I really...really aprreciate it this. Makes Memorial Day a day to remember,,especially me..a vet for 24 years.. Thank God to all of you.. -----Original Message----- Try =IF(Project!C5="","",Project!C5) -- For everyone's benefit keep the discussion in the newsgroup. Regards, Peo Sjoblom "A Rios" wrote in message ... Thanks for the help, bit it did not work The function I use below displays a values of 0 (Zero) when nothing is in that field. =Project!C5 (if this field is blank it displays a zero). I could use the tools option to not display zeros but if we want to add other numerical fields and display zeros then it's not feasible. Can you help..This is the last request.. We ( My Son and I ) greatly appreciate the support. -----Original Message----- Hi this works only if cell D10 conatins a #NA error. If you want to check for any error try =if(ISERROR(Project!D10)),"". -- Regards Frank Kabel Frankfurt, Germany Al Rios wrote: Just typed it in and it works fantastic. I tried to use the same concept for anther field but no luck. Can you help =if(ISNA(Project!D10)),"". You guys are great.... -----Original Message----- Hi Al, I just tried the formula and it works fine. However, I did get the error when I first copied/pasted it into my worksheet. I think hard returns seemed to have been the problem, probably due to copying/pasting. You'll find that if you type it in, you won't have a problem. Hope this helps! In article 15a9e01c4470f$3c225120 , "Al Rios" wrote: Get an Error, It states the "Formula You enter contains an Error" This is what I have: E1 thru H1 are text Values from the header E2 thru H2 are date values.. Above may help.. Thanks very much.. . . . . |
#27
|
|||
|
|||
Insert Cell Name of a value that matches a MAX function
Hi
you'll get this if ALL cells are blank. Try something like =IF(COUNTA(Project!E2:H2),MAX(Project!E2:H2),"") or =IF(MAX(Project!E2:H2)0,MAX(Project!E2:H2),"") -- Regards Frank Kabel Frankfurt, Germany Al Rios wrote: The cell that the value is inserting is formated as a date field and I get these values when the cell I point to is blank and inserts it in the cell I want to. 01/00/00 01/00/00 01/00/00 01/00/00 01/00/00 01/00/00 01/00/00 01/00/00 01/00/00 01/00/00 Thanks -----Original Message----- Hi for the MAX function you don't have to check for blank cells. Excel will omitt them automatically -- Regards Frank Kabel Frankfurt, Germany Al Rios wrote: Works Great,, one more item I forgot I want to do the same for the below format =MAX(Project!E2:H2) All of you guys are great...You don't know how much my son is understanding the importance of education. I really...really aprreciate it this. Makes Memorial Day a day to remember,,especially me..a vet for 24 years.. Thank God to all of you.. -----Original Message----- Try =IF(Project!C5="","",Project!C5) -- For everyone's benefit keep the discussion in the newsgroup. Regards, Peo Sjoblom "A Rios" wrote in message ... Thanks for the help, bit it did not work The function I use below displays a values of 0 (Zero) when nothing is in that field. =Project!C5 (if this field is blank it displays a zero). I could use the tools option to not display zeros but if we want to add other numerical fields and display zeros then it's not feasible. Can you help..This is the last request.. We ( My Son and I ) greatly appreciate the support. -----Original Message----- Hi this works only if cell D10 conatins a #NA error. If you want to check for any error try =if(ISERROR(Project!D10)),"". -- Regards Frank Kabel Frankfurt, Germany Al Rios wrote: Just typed it in and it works fantastic. I tried to use the same concept for anther field but no luck. Can you help =if(ISNA(Project!D10)),"". You guys are great.... -----Original Message----- Hi Al, I just tried the formula and it works fine. However, I did get the error when I first copied/pasted it into my worksheet. I think hard returns seemed to have been the problem, probably due to copying/pasting. You'll find that if you type it in, you won't have a problem. Hope this helps! In article 15a9e01c4470f$3c225120 , "Al Rios" wrote: Get an Error, It states the "Formula You enter contains an Error" This is what I have: E1 thru H1 are text Values from the header E2 thru H2 are date values.. Above may help.. Thanks very much.. . . . . |
#28
|
|||
|
|||
Insert Cell Name of a value that matches a MAX function
Since you are using max that would only be a problem if all the cells
are empty in the linked cells? If that could be the case you could do the same and use =IF(linkcell="","",linkcell) or =IF(COUNT(Linked_cell_range),MAX(Project!E2:H2),"" ) format result as date -- For everyone's benefit keep the discussion in the newsgroup. Regards, Peo Sjoblom "Al Rios" wrote in message ... The cell that the value is inserting is formated as a date field and I get these values when the cell I point to is blank and inserts it in the cell I want to. 01/00/00 01/00/00 01/00/00 01/00/00 01/00/00 01/00/00 01/00/00 01/00/00 01/00/00 01/00/00 Thanks -----Original Message----- Hi for the MAX function you don't have to check for blank cells. Excel will omitt them automatically -- Regards Frank Kabel Frankfurt, Germany Al Rios wrote: Works Great,, one more item I forgot I want to do the same for the below format =MAX(Project!E2:H2) All of you guys are great...You don't know how much my son is understanding the importance of education. I really...really aprreciate it this. Makes Memorial Day a day to remember,,especially me..a vet for 24 years.. Thank God to all of you.. -----Original Message----- Try =IF(Project!C5="","",Project!C5) -- For everyone's benefit keep the discussion in the newsgroup. Regards, Peo Sjoblom "A Rios" wrote in message ... Thanks for the help, bit it did not work The function I use below displays a values of 0 (Zero) when nothing is in that field. =Project!C5 (if this field is blank it displays a zero). I could use the tools option to not display zeros but if we want to add other numerical fields and display zeros then it's not feasible. Can you help..This is the last request.. We ( My Son and I ) greatly appreciate the support. -----Original Message----- Hi this works only if cell D10 conatins a #NA error. If you want to check for any error try =if(ISERROR(Project!D10)),"". -- Regards Frank Kabel Frankfurt, Germany Al Rios wrote: Just typed it in and it works fantastic. I tried to use the same concept for anther field but no luck. Can you help =if(ISNA(Project!D10)),"". You guys are great.... -----Original Message----- Hi Al, I just tried the formula and it works fine. However, I did get the error when I first copied/pasted it into my worksheet. I think hard returns seemed to have been the problem, probably due to copying/pasting. You'll find that if you type it in, you won't have a problem. Hope this helps! In article 15a9e01c4470f$3c225120 , "Al Rios" wrote: Get an Error, It states the "Formula You enter contains an Error" This is what I have: E1 thru H1 are text Values from the header E2 thru H2 are date values.. Above may help.. Thanks very much.. . . . . |
#29
|
|||
|
|||
Insert Cell Name of a value that matches a MAX function
Yes...Yes the
=IF(MAX(Project!E2:H2)0,MAX(Project!E2:H2),"") Worked Fantastic..... God bless you all.. Al.. -----Original Message----- Hi you'll get this if ALL cells are blank. Try something like =IF(COUNTA(Project!E2:H2),MAX(Project!E2:H2),"" ) or =IF(MAX(Project!E2:H2)0,MAX(Project!E2:H2),"") -- Regards Frank Kabel Frankfurt, Germany Al Rios wrote: The cell that the value is inserting is formated as a date field and I get these values when the cell I point to is blank and inserts it in the cell I want to. 01/00/00 01/00/00 01/00/00 01/00/00 01/00/00 01/00/00 01/00/00 01/00/00 01/00/00 01/00/00 Thanks -----Original Message----- Hi for the MAX function you don't have to check for blank cells. Excel will omitt them automatically -- Regards Frank Kabel Frankfurt, Germany Al Rios wrote: Works Great,, one more item I forgot I want to do the same for the below format =MAX(Project!E2:H2) All of you guys are great...You don't know how much my son is understanding the importance of education. I really...really aprreciate it this. Makes Memorial Day a day to remember,,especially me..a vet for 24 years.. Thank God to all of you.. -----Original Message----- Try =IF(Project!C5="","",Project!C5) -- For everyone's benefit keep the discussion in the newsgroup. Regards, Peo Sjoblom "A Rios" wrote in message ... Thanks for the help, bit it did not work The function I use below displays a values of 0 (Zero) when nothing is in that field. =Project!C5 (if this field is blank it displays a zero). I could use the tools option to not display zeros but if we want to add other numerical fields and display zeros then it's not feasible. Can you help..This is the last request.. We ( My Son and I ) greatly appreciate the support. -----Original Message----- Hi this works only if cell D10 conatins a #NA error. If you want to check for any error try =if(ISERROR(Project!D10)),"". -- Regards Frank Kabel Frankfurt, Germany Al Rios wrote: Just typed it in and it works fantastic. I tried to use the same concept for anther field but no luck. Can you help =if(ISNA(Project!D10)),"". You guys are great.... -----Original Message----- Hi Al, I just tried the formula and it works fine. However, I did get the error when I first copied/pasted it into my worksheet. I think hard returns seemed to have been the problem, probably due to copying/pasting. You'll find that if you type it in, you won't have a problem. Hope this helps! In article 15a9e01c4470f$3c225120 , "Al Rios" wrote: Get an Error, It states the "Formula You enter contains an Error" This is what I have: E1 thru H1 are text Values from the header E2 thru H2 are date values.. Above may help.. Thanks very much.. . . . . . |
Thread Tools | |
Display Modes | |
|
|