help with forumla needed... getting a yes/no answer to ??

[shorn]

Im trying to create a formula in Excel but im having some problems. Im not even sure that it can be done!
Basically the cell that the formula is in must return a "yes" or "no".

I want the formula to reference three seperate cells in that row. Basically it should return a "yes" if the first cell has a value greater to or equal to 10000, the second cell is greater or equal to 4 and the third cell has a value of 1. Basically if it does match this criteria it should return with a "No".

Any help on creating this would be very apprciated TIA!

[Max]

One way ..
Assuming the 3 cells are A1, B1 & C1,
Put in say, D1: =IF(AND(A1>=10000,B1>=4,C1=1),"No","Yes")
Copy D1 down to return likewise for the other values in cols A to C
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"shorn" <[email protected]> wrote in
message news:[email protected]...
>
> Im trying to create a formula in Excel but im having some problems. Im
> not even sure that it can be done!
> Basically the cell that the formula is in must return a "yes" or "no".
>
>
> I want the formula to reference three seperate cells in that row.
> Basically it should return a "yes" if the first cell has a value
> greater to or equal to 10000, the second cell is greater or equal to 4
> and the third cell has a value of 1. Basically if it does match this
> criteria it should return with a "No".
>
> Any help on creating this would be very apprciated TIA!
>
>
> --
> shorn
> ------------------------------------------------------------------------
> shorn's Profile:
http://www.excelforum.com/member.php...o&userid=23835
> View this thread: http://www.excelforum.com/showthread...hreadid=374881
>