You have to have Yellow in B1 AND at the same time Green in B2.

If you have both those values in those cells and you don't get BASIC, you could
be in manual calculation mode.

In xl2003 menus:
Tools|Options|Calculation tab
change it to automatic

If you're in automatic mode, then you don't have yellow and green (exactly) in
those cells. Maybe you have extra spaces in the cells????

I'd retype them and see what happens.

ABBY wrote:

That formula doesn't work. It always brings up "Other than Basic" even when
I have yellow in the field.

"Fred Smith" wrote:

No. It would be:

=if(and(b1="yellow",b2="green"),"BASIC","Other than Basic")

Regards,
Fred.

"ABBY" wrote in message
...
if i want to say Yellow and green would be basic would the formula be

=IF(B1="yellow,green","BASIC","Why Not Yellow?")

"Russ_Hiatt" wrote:

in cell A1 place an if statement (=IF(B1="yellow","BASIC","Why Not
Yellow?"))but thats will only show basic if its yellow and not for any
other
color. If they dont say "yellow" then "why Not Yellow" will be in A1. you
can
do the same for A2 just with different wording.

"ABBY" wrote:

i am trying to create a formula to allow the cell to autopopulate a
category.
For example
If I type "yellow" in B1 I want "BASIC" to appear in A1
If I type "green" in B2 I want "PRIMARY" to appear in A2



--

Dave Peterson