View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mldancing mldancing is offline
external usenet poster
 
Posts: 28
Default Nested if with "wild card"

Would really appreciate it if you can help with the following nested if
example:

Example:

A1 B1
Large 2009 100
Medium 2009 200
Medium 2008 500
Large 2008 300
Other 2009 400

I want to set up a nested if formula to pick up the value in B1 if there is
the word
"Large" in A1 or if there's "Medium" in A1, else enter zero.

I was going with this but it didn't work:
=if(or(A1="Large*",A1="Medium*"),B1,0)

Can someone help? Thank you.