combine the two into a single formula please

Guest · Sep 8, 2005

Hello from Steved

combine the two below into a single formula please

=IF(Master!R6=4, ROW(),"")
=IF(Master!R6="W", ROW(),"")

Rowan · Sep 8, 2005

One way:

=IF(OR(Master!R6=4,Master!R6="W"), ROW(),"")

Regards
Rowan

Guest · Sep 8, 2005

Thanks Rowan

Rowan said:
One way:

=IF(OR(Master!R6=4,Master!R6="W"), ROW(),"")

Regards
Rowan

Rowan · Sep 8, 2005

You're welcome.

Thanks Rowan

: