how to combine and's with or's in a if statement
 

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

how to combine and's with or's in a if statement
 

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

how to combine and's with or's in a if statement
 

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

how to combine and's with or's in a if statement
 

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