Insert Cell Name of a value that matches a MAX function

[Peo Sjoblom]

Try

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

--


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

Regards,

Peo Sjoblom

 

[Al Rios]

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

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.

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!

 

[Frank Kabel]

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

 

[Al Rios]

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!

 

[Al Rios]

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.

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

--
Regards
Frank Kabel
Frankfurt, Germany

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!

 

[Frank Kabel]

Hi
for the MAX function you don't have to check for blank cells. Excel
will omitt them automatically

 

[Al Rios]

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

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!

 

[Frank Kabel]

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),"")

 

[Peo Sjoblom]

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

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

 

[Al Rios]

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

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!