If "A" is constant for both or conditions, how does one write the if
statement? I tried to do this and got and error:
If(or($b4="UA", sum($r4+$t40, and($a4="S")),1,2)
--
Rick Rack

Hi Rick,

You have a syntax error (missing closing parenthesis): sum($r4+$t40
correct: sum($r4+$t4)0

But I can't tell wether your formula gives the result you want, because you
don't tell us what you want exactly!

Regards,
Stefi

€žRick€� ezt Ã*rta:

If "A" is constant for both or conditions, how does one write the if
statement? I tried to do this and got and error:
If(or($b4="UA", sum($r4+$t40, and($a4="S")),1,2)
--
Rick Rack

Rick,
Is this what you require?

=IF(AND(OR($B4="UA",$R4+$T40), ($A4="S")),1,2)

If B4="UA OR R4+T40 AND A4="S" then results is 1, otherwise 2

"Rick" wrote:

If "A" is constant for both or conditions, how does one write the if
statement? I tried to do this and got and error:
If(or($b4="UA", sum($r4+$t40, and($a4="S")),1,2)
--
Rick Rack

maybe

=IF(OR($B4="UA",AND($R4+$T40,$A4="S")),1,2)

but where is A constant?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Rick" wrote in message
...
If "A" is constant for both or conditions, how does one write the if
statement? I tried to do this and got and error:
If(or($b4="UA", sum($r4+$t40, and($a4="S")),1,2)
--
Rick Rack