Thread: "OR" in Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Barb Barb is offline
external usenet poster
 
Posts: 70
Default "OR" in Formula

I'm trying to create a formula that basically says:
IF a2 = BC or WWW, then insert the number 60, else if a2 = FR or FH, then
insert the number 120, else if a2 = SS or BS or PS or AS, then insert the
number 200.

This has me totally confused... I've done other similar calculations but
never using 'OR'.
--
Thanks!
Barb