"OR" in Formula
hi
try..
=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,"" )))
careful. the formula wrapped
Regards
FSt1
"Barb" wrote:
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
|