Conditional Formating
 

Hello experts

I have a cell which have a formula and shows a percentage of growth.
However, some cells result in #DIV . I would like to have a conditional
formating which can show "N/A" instead of #DIV in the worksheet. How can I do
it?

If conditional formating cannot do it, any other ways to do it?

Thanks alot.

Conditional Formating
 

Modify this

=IF(ISERROR(formula),"N/A",formula)
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"kaci" wrote:

Hello experts

I have a cell which have a formula and shows a percentage of growth.
However, some cells result in #DIV . I would like to have a conditional
formating which can show "N/A" instead of #DIV in the worksheet. How can I do
it?

If conditional formating cannot do it, any other ways to do it?

Thanks alot.

Conditional Formating
 

I tried, but it doesnt work........ is there any other ways to do?

"John Bundy" wrote:

Modify this

=IF(ISERROR(formula),"N/A",formula)
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"kaci" wrote:

Hello experts

I have a cell which have a formula and shows a percentage of growth.
However, some cells result in #DIV . I would like to have a conditional
formating which can show "N/A" instead of #DIV in the worksheet. How can I do
it?

If conditional formating cannot do it, any other ways to do it?

Thanks alot.

Conditional Formating
 

Post the formula that's returning the #DIV/0! error.

Biff

"kaci" wrote in message
...
I tried, but it doesnt work........ is there any other ways to do?

"John Bundy" wrote:

Modify this

=IF(ISERROR(formula),"N/A",formula)
--
-John Northwest11
Please rate when your question is answered to help us and others know
what
is helpful.


"kaci" wrote:

Hello experts

I have a cell which have a formula and shows a percentage of growth.
However, some cells result in #DIV . I would like to have a
conditional
formating which can show "N/A" instead of #DIV in the worksheet. How
can I do
it?

If conditional formating cannot do it, any other ways to do it?

Thanks alot.

Conditional Formating
 

Formula: =+AR23/(AO23*0.25)-1

Where AO23 is 0.



"T. Valko" wrote:

Post the formula that's returning the #DIV/0! error.

Biff

"kaci" wrote in message
...
I tried, but it doesnt work........ is there any other ways to do?

"John Bundy" wrote:

Modify this

=IF(ISERROR(formula),"N/A",formula)
--
-John Northwest11
Please rate when your question is answered to help us and others know
what
is helpful.


"kaci" wrote:

Hello experts

I have a cell which have a formula and shows a percentage of growth.
However, some cells result in #DIV . I would like to have a
conditional
formating which can show "N/A" instead of #DIV in the worksheet. How
can I do
it?

If conditional formating cannot do it, any other ways to do it?

Thanks alot.

Conditional Formating
 

Try this:

=IF(AO23=0,"N/A",AR23/(AO23*0.25)-1)

Biff

"kaci" wrote in message
...
Formula: =+AR23/(AO23*0.25)-1

Where AO23 is 0.



"T. Valko" wrote:

Post the formula that's returning the #DIV/0! error.

Biff

"kaci" wrote in message
...
I tried, but it doesnt work........ is there any other ways to do?

"John Bundy" wrote:

Modify this

=IF(ISERROR(formula),"N/A",formula)
--
-John Northwest11
Please rate when your question is answered to help us and others know
what
is helpful.


"kaci" wrote:

Hello experts

I have a cell which have a formula and shows a percentage of growth.
However, some cells result in #DIV . I would like to have a
conditional
formating which can show "N/A" instead of #DIV in the worksheet. How
can I do
it?

If conditional formating cannot do it, any other ways to do it?

Thanks alot.

Conditional Formating
 

In what way does =IF(ISERROR(AR23/(AO23*0.25)-1),"N/A",AR23/(AO23*0.25)-1)
not work?
What symptoms are you seeing?
--
David Biddulph

"kaci" wrote in message
...
I tried, but it doesnt work........ is there any other ways to do?

"John Bundy" wrote:

Modify this

=IF(ISERROR(formula),"N/A",formula)

"kaci" wrote:

Hello experts

I have a cell which have a formula and shows a percentage of growth.
However, some cells result in #DIV . I would like to have a
conditional
formating which can show "N/A" instead of #DIV in the worksheet. How
can I do
it?

If conditional formating cannot do it, any other ways to do it?

Thanks alot.

Conditional Formating
 

Then something weird is going on, put this in, it causes a #DIV error and
then corrects it, try to modify it or post your formula he
=IF(ISERROR(1/0),"N/A","")
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"kaci" wrote:

I tried, but it doesnt work........ is there any other ways to do?

"John Bundy" wrote:

Modify this

=IF(ISERROR(formula),"N/A",formula)
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"kaci" wrote:

Hello experts

I have a cell which have a formula and shows a percentage of growth.
However, some cells result in #DIV . I would like to have a conditional
formating which can show "N/A" instead of #DIV in the worksheet. How can I do
it?

If conditional formating cannot do it, any other ways to do it?

Thanks alot.