Here is my challenge:
I have already used all 3 conditions. I need one condition to execute when
a value = approved OR n/a.
my problem is that i can do one or the other, but no both in the same
condition- how do you do that?
thanks!
Here is my challenge:
I have already used all 3 conditions. I need one condition to execute when
a value = approved OR n/a.
my problem is that i can do one or the other, but no both in the same
condition- how do you do that?
thanks!
Hi Brendan,
> my problem is that i can do one or the other, but no both in the same
> condition- how do you do that?
Formula is: =OR($A$1="approvedd",$A$1="n/a")
---
Regards,
Norman
"brendan" <[email protected]> wrote in message
news:[email protected]...
> Here is my challenge:
>
> I have already used all 3 conditions. I need one condition to execute
> when
> a value = approved OR n/a.
>
> my problem is that i can do one or the other, but no both in the same
> condition- how do you do that?
>
> thanks!
On the face of it ..
> .. I need one condition to execute when
> a value = approved OR n/a.
Think using CF formulas in say, Condition 1 such as:
Formula is: =OR($A1="Approved",$A1="N/A")
(if the "n/a" within col A is text)
Or, if col A contains formulas which could evaluate to #N/A
Formula is: =IF(ISNA($A1),1,$A1="Approved")
could accomplish the desired conditional checks
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"brendan" <[email protected]> wrote in message
news:[email protected]...
> Here is my challenge:
>
> I have already used all 3 conditions. I need one condition to execute
when
> a value = approved OR n/a.
>
> my problem is that i can do one or the other, but no both in the same
> condition- how do you do that?
>
> thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks