Thread
:
formula help needed (if values)
View Single Post
#
2
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
formula help needed (if values)
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.
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann