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

S

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!
 
M

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
 
Top