Insert Cell Name of a value that matches a MAX function

  • Thread starter Thread starter Al Rios
  • Start date Start date
Try

=IF(Project!C5="","",Project!C5)

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
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 said:
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.
Click to expand...
However, I did get
the 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!
Click to expand...
Click to expand...
Click to expand...
 
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

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
Click to expand...
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.
Click to expand...
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
Click to expand...
due
to
copying/pasting.

You'll find that if you type it in, you won't have
Click to expand...
a
problem.
Hope this helps!
Click to expand...
Click to expand...
Click to expand...
 
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

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.
Click to expand...

-----Original Message-----
Hi
use Peo's suggestion then:
=IF(Project!D10="","",Project!D10)

--
Regards
Frank Kabel
Frankfurt, Germany


Al said:
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!
Click to expand...
Click to expand...
Click to expand...
 
Hi
for the MAX function you don't have to check for blank cells. Excel
will omitt them automatically
 
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 said:
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

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!
Click to expand...
Click to expand...
Click to expand...
 
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),"")
 
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 said:
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
Click to expand...
Click to expand...
 
Yes...Yes the

=IF(MAX(Project!E2:H2)>0,MAX(Project!E2:H2),"")
Click to expand...

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 said:
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

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!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top