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

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

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 <atyahoo<dotcom
----
"shorn" wrote in
message ...

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