| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formating is greyed out and unavailable | Excel Discussion (Misc queries) | |||
| Conditional Formating | Excel Discussion (Misc queries) | |||
| excel conditional formating decimal fractions | Excel Worksheet Functions | |||
| Conditional formating using formulas | Excel Worksheet Functions | |||
| VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
Linear Mode
