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