Thread: "OR" in Formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default "OR" in Formula

What you've asked for is this:
=IF(OR(A2="BC",A2="WWW"),60,IF(OR(A2="FR",A2="FH") ,120,IF(OR(A2="SS",A2="BS",A2="PS",A2="AS"),200,"n ot
in list")))

Personally, I would create a list, and use Vlookup.

Regards,
Fred

"Barb" wrote in message
...
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