Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
yes/no option buttons | Excel Discussion (Misc queries) |