Hi Barb,

Consider a defined name for your formula.


--
Kind regards,

Niek Otten

"Barb Reinhardt" wrote in message
...
|I thought about that, but would prefer not to as I already have a lot in this
| worksheet.
|
| Thanks for your help.
|
| "Niek Otten" wrote:
|
| Hi Barb,
|
| I don't know the restrictions you might have, but if possible I would always store the A formula in a cell and use that
address to
| compare.
|
| --
| Kind regards,
|
| Niek Otten
|
| "Barb Reinhardt" wrote in message
| ...
| | My formula currently looks like this
| |
| | =if(or(A=Green,A=Yellow,A=Red),1,0)
| |
| | unfortunately A is a fairly long formula. Is there a more elegant way to do
| | this?
| |
| | Thanks,
| | Barb Reinhardt
|
|
|