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

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!

2. ## Re: help with forumla needed... getting a yes/no answer to ??

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" <shorn.1pscyb_1117357508.2388@excelforum-nospam.com> wrote in
message news:shorn.1pscyb_1117357508.2388@excelforum-nospam.com...
>
> 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
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1