i need help with making a formula

i want it to mean that if B4=C4 OR bunch, or stems then it will enter
the valueiftrue and then as normal, the valueiffalse.

here's a screenshot to help.

http://i86.photobucket.com/albums/k9...screenshot.jpg

if anyone could give me a formula to help me with this, i'd apreciate
it.

If I understand you correctly try:

=IF(OR(B4=C4,B4="Bunches",B4="Stems"),"Value if TRUE", "Value if FALSE")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


wrote in message
oups.com...
i need help with making a formula

i want it to mean that if B4=C4 OR bunch, or stems then it will enter
the valueiftrue and then as normal, the valueiffalse.

here's a screenshot to help.

http://i86.photobucket.com/albums/k9...screenshot.jpg

if anyone could give me a formula to help me with this, i'd apreciate
it.

A bit of overkill but try this idea
=IF(SUMPRODUCT((C8=B8)+(C8={"b","c"}))0,"good","b ad")

--
Don Guillett
SalesAid Software

wrote in message
oups.com...
i need help with making a formula

i want it to mean that if B4=C4 OR bunch, or stems then it will enter
the valueiftrue and then as normal, the valueiffalse.

here's a screenshot to help.

http://i86.photobucket.com/albums/k9...screenshot.jpg

if anyone could give me a formula to help me with this, i'd apreciate
it.

=IF(B4="bunch",H4,IF(B4="stems",H4,"Try Again"))

To save typing I wrote Nice Job in H4.

Mike

" wrote:

i need help with making a formula

i want it to mean that if B4=C4 OR bunch, or stems then it will enter
the valueiftrue and then as normal, the valueiffalse.

here's a screenshot to help.

http://i86.photobucket.com/albums/k9...screenshot.jpg

if anyone could give me a formula to help me with this, i'd apreciate
it.