View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darin Kramer Darin Kramer is offline
external usenet poster
 
Posts: 397
Default If, Or and an And

Me again.... :)

Should be simple, but for some reason I can get it to work...

Formulae in cell a5, needs to say...
If cell a1 = "Bird", then display cell b1
If cell a1 = "Cat", then display cell b2
If cell a1 - "Seed" or "Dish" then display "N/A"

I thought it was a nested if with an and and a or, but mine does not
seem to work...

Thanks guys....



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!