If statement - 2 tests

[RobertLees]

Hi

How can I test 2 criteria to set a cell value? I think there is an =if(or---etc, but what syntax should I use.

Thanks
Robert

[William]

Hi Robert

=IF(OR(A1=5,A1=10),"Its 5 or 10","")

--


XL2003
Regards

William
[email protected]


"RobertLees" <[email protected]> wrote
in message news:[email protected]...
>
> Hi
>
> How can I test 2 criteria to set a cell value? I think there is an
> =if(or---etc, but what syntax should I use.
>
> Thanks
> Robert
>
>
> --
> RobertLees
> ------------------------------------------------------------------------
> RobertLees's Profile:
> http://www.excelforum.com/member.php...o&userid=26580
> View this thread: http://www.excelforum.com/showthread...hreadid=401072
>

[William]

Hi Robert

=IF(OR(A1=5,A1=10),"Its 5 or 10","")

--


XL2003
Regards

William
[email protected]


"RobertLees" <[email protected]> wrote
in message news:[email protected]...
>
> Hi
>
> How can I test 2 criteria to set a cell value? I think there is an
> =if(or---etc, but what syntax should I use.
>
> Thanks
> Robert
>
>
> --
> RobertLees
> ------------------------------------------------------------------------
> RobertLees's Profile:
> http://www.excelforum.com/member.php...o&userid=26580
> View this thread: http://www.excelforum.com/showthread...hreadid=401072
>

[William]

Hi Robert

=IF(OR(A1=5,A1=10),"Its 5 or 10","")

--


XL2003
Regards

William
[email protected]


"RobertLees" <[email protected]> wrote
in message news:[email protected]...
>
> Hi
>
> How can I test 2 criteria to set a cell value? I think there is an
> =if(or---etc, but what syntax should I use.
>
> Thanks
> Robert
>
>
> --
> RobertLees
> ------------------------------------------------------------------------
> RobertLees's Profile:
> http://www.excelforum.com/member.php...o&userid=26580
> View this thread: http://www.excelforum.com/showthread...hreadid=401072
>

[William]

Hi Robert

=IF(OR(A1=5,A1=10),"Its 5 or 10","")

--


XL2003
Regards

William
[email protected]


"RobertLees" <[email protected]> wrote
in message news:[email protected]...
>
> Hi
>
> How can I test 2 criteria to set a cell value? I think there is an
> =if(or---etc, but what syntax should I use.
>
> Thanks
> Robert
>
>
> --
> RobertLees
> ------------------------------------------------------------------------
> RobertLees's Profile:
> http://www.excelforum.com/member.php...o&userid=26580
> View this thread: http://www.excelforum.com/showthread...hreadid=401072
>

[William]

Hi Robert

=IF(OR(A1=5,A1=10),"Its 5 or 10","")

--


XL2003
Regards

William
[email protected]


"RobertLees" <[email protected]> wrote
in message news:[email protected]...
>
> Hi
>
> How can I test 2 criteria to set a cell value? I think there is an
> =if(or---etc, but what syntax should I use.
>
> Thanks
> Robert
>
>
> --
> RobertLees
> ------------------------------------------------------------------------
> RobertLees's Profile:
> http://www.excelforum.com/member.php...o&userid=26580
> View this thread: http://www.excelforum.com/showthread...hreadid=401072
>

[William]

Hi Robert

=IF(OR(A1=5,A1=10),"Its 5 or 10","")

--


XL2003
Regards

William
[email protected]


"RobertLees" <[email protected]> wrote
in message news:[email protected]...
>
> Hi
>
> How can I test 2 criteria to set a cell value? I think there is an
> =if(or---etc, but what syntax should I use.
>
> Thanks
> Robert
>
>
> --
> RobertLees
> ------------------------------------------------------------------------
> RobertLees's Profile:
> http://www.excelforum.com/member.php...o&userid=26580
> View this thread: http://www.excelforum.com/showthread...hreadid=401072
>

[William]

Hi Robert

=IF(OR(A1=5,A1=10),"Its 5 or 10","")

--


XL2003
Regards

William
[email protected]


"RobertLees" <[email protected]> wrote
in message news:[email protected]...
>
> Hi
>
> How can I test 2 criteria to set a cell value? I think there is an
> =if(or---etc, but what syntax should I use.
>
> Thanks
> Robert
>
>
> --
> RobertLees
> ------------------------------------------------------------------------
> RobertLees's Profile:
> http://www.excelforum.com/member.php...o&userid=26580
> View this thread: http://www.excelforum.com/showthread...hreadid=401072
>

[William]

Hi Robert

=IF(OR(A1=5,A1=10),"Its 5 or 10","")

--


XL2003
Regards

William
[email protected]


"RobertLees" <[email protected]> wrote
in message news:[email protected]...
>
> Hi
>
> How can I test 2 criteria to set a cell value? I think there is an
> =if(or---etc, but what syntax should I use.
>
> Thanks
> Robert
>
>
> --
> RobertLees
> ------------------------------------------------------------------------
> RobertLees's Profile:
> http://www.excelforum.com/member.php...o&userid=26580
> View this thread: http://www.excelforum.com/showthread...hreadid=401072
>

[William]

Hi Robert

=IF(OR(A1=5,A1=10),"Its 5 or 10","")

--


XL2003
Regards

William
[email protected]


"RobertLees" <[email protected]> wrote
in message news:[email protected]...
>
> Hi
>
> How can I test 2 criteria to set a cell value? I think there is an
> =if(or---etc, but what syntax should I use.
>
> Thanks
> Robert
>
>
> --
> RobertLees
> ------------------------------------------------------------------------
> RobertLees's Profile:
> http://www.excelforum.com/member.php...o&userid=26580
> View this thread: http://www.excelforum.com/showthread...hreadid=401072
>

[William]

Hi Robert

=IF(OR(A1=5,A1=10),"Its 5 or 10","")

--


XL2003
Regards

William
[email protected]


"RobertLees" <[email protected]> wrote
in message news:[email protected]...
>
> Hi
>
> How can I test 2 criteria to set a cell value? I think there is an
> =if(or---etc, but what syntax should I use.
>
> Thanks
> Robert
>
>
> --
> RobertLees
> ------------------------------------------------------------------------
> RobertLees's Profile:
> http://www.excelforum.com/member.php...o&userid=26580
> View this thread: http://www.excelforum.com/showthread...hreadid=401072
>

[William]

Hi Robert

=IF(OR(A1=5,A1=10),"Its 5 or 10","")

--


XL2003
Regards

William
[email protected]


"RobertLees" <[email protected]> wrote
in message news:[email protected]...
>
> Hi
>
> How can I test 2 criteria to set a cell value? I think there is an
> =if(or---etc, but what syntax should I use.
>
> Thanks
> Robert
>
>
> --
> RobertLees
> ------------------------------------------------------------------------
> RobertLees's Profile:
> http://www.excelforum.com/member.php...o&userid=26580
> View this thread: http://www.excelforum.com/showthread...hreadid=401072
>

[William]

Hi Robert

=IF(OR(A1=5,A1=10),"Its 5 or 10","")

--


XL2003
Regards

William
[email protected]


"RobertLees" <[email protected]> wrote
in message news:[email protected]...
>
> Hi
>
> How can I test 2 criteria to set a cell value? I think there is an
> =if(or---etc, but what syntax should I use.
>
> Thanks
> Robert
>
>
> --
> RobertLees
> ------------------------------------------------------------------------
> RobertLees's Profile:
> http://www.excelforum.com/member.php...o&userid=26580
> View this thread: http://www.excelforum.com/showthread...hreadid=401072
>

[William]

Hi Robert

=IF(OR(A1=5,A1=10),"Its 5 or 10","")

--


XL2003
Regards

William
[email protected]


"RobertLees" <[email protected]> wrote
in message news:[email protected]...
>
> Hi
>
> How can I test 2 criteria to set a cell value? I think there is an
> =if(or---etc, but what syntax should I use.
>
> Thanks
> Robert
>
>
> --
> RobertLees
> ------------------------------------------------------------------------
> RobertLees's Profile:
> http://www.excelforum.com/member.php...o&userid=26580
> View this thread: http://www.excelforum.com/showthread...hreadid=401072
>

[William]

Hi Robert

=IF(OR(A1=5,A1=10),"Its 5 or 10","")

--


XL2003
Regards

William
[email protected]


"RobertLees" <[email protected]> wrote
in message news:[email protected]...
>
> Hi
>
> How can I test 2 criteria to set a cell value? I think there is an
> =if(or---etc, but what syntax should I use.
>
> Thanks
> Robert
>
>
> --
> RobertLees
> ------------------------------------------------------------------------
> RobertLees's Profile:
> http://www.excelforum.com/member.php...o&userid=26580
> View this thread: http://www.excelforum.com/showthread...hreadid=401072
>

[William]

Hi Robert

=IF(OR(A1=5,A1=10),"Its 5 or 10","")

--


XL2003
Regards

William
[email protected]


"RobertLees" <[email protected]> wrote
in message news:[email protected]...
>
> Hi
>
> How can I test 2 criteria to set a cell value? I think there is an
> =if(or---etc, but what syntax should I use.
>
> Thanks
> Robert
>
>
> --
> RobertLees
> ------------------------------------------------------------------------
> RobertLees's Profile:
> http://www.excelforum.com/member.php...o&userid=26580
> View this thread: http://www.excelforum.com/showthread...hreadid=401072
>

[William]

Hi Robert

=IF(OR(A1=5,A1=10),"Its 5 or 10","")

--


XL2003
Regards

William
[email protected]


"RobertLees" <[email protected]> wrote
in message news:[email protected]...
>
> Hi
>
> How can I test 2 criteria to set a cell value? I think there is an
> =if(or---etc, but what syntax should I use.
>
> Thanks
> Robert
>
>
> --
> RobertLees
> ------------------------------------------------------------------------
> RobertLees's Profile:
> http://www.excelforum.com/member.php...o&userid=26580
> View this thread: http://www.excelforum.com/showthread...hreadid=401072
>

[William]

Hi Robert

=IF(OR(A1=5,A1=10),"Its 5 or 10","")

--


XL2003
Regards

William
[email protected]


"RobertLees" <[email protected]> wrote
in message news:[email protected]...
>
> Hi
>
> How can I test 2 criteria to set a cell value? I think there is an
> =if(or---etc, but what syntax should I use.
>
> Thanks
> Robert
>
>
> --
> RobertLees
> ------------------------------------------------------------------------
> RobertLees's Profile:
> http://www.excelforum.com/member.php...o&userid=26580
> View this thread: http://www.excelforum.com/showthread...hreadid=401072
>

[William]

Hi Robert

=IF(OR(A1=5,A1=10),"Its 5 or 10","")

--


XL2003
Regards

William
[email protected]


"RobertLees" <[email protected]> wrote
in message news:[email protected]...
>
> Hi
>
> How can I test 2 criteria to set a cell value? I think there is an
> =if(or---etc, but what syntax should I use.
>
> Thanks
> Robert
>
>
> --
> RobertLees
> ------------------------------------------------------------------------
> RobertLees's Profile:
> http://www.excelforum.com/member.php...o&userid=26580
> View this thread: http://www.excelforum.com/showthread...hreadid=401072
>

[William]

Hi Robert

=IF(OR(A1=5,A1=10),"Its 5 or 10","")

--


XL2003
Regards

William
[email protected]


"RobertLees" <[email protected]> wrote
in message news:[email protected]...
>
> Hi
>
> How can I test 2 criteria to set a cell value? I think there is an
> =if(or---etc, but what syntax should I use.
>
> Thanks
> Robert
>
>
> --
> RobertLees
> ------------------------------------------------------------------------
> RobertLees's Profile:
> http://www.excelforum.com/member.php...o&userid=26580
> View this thread: http://www.excelforum.com/showthread...hreadid=401072
>

[William]

Hi Robert

=IF(OR(A1=5,A1=10),"Its 5 or 10","")

--


XL2003
Regards

William
[email protected]


"RobertLees" <[email protected]> wrote
in message news:[email protected]...
>
> Hi
>
> How can I test 2 criteria to set a cell value? I think there is an
> =if(or---etc, but what syntax should I use.
>
> Thanks
> Robert
>
>
> --
> RobertLees
> ------------------------------------------------------------------------
> RobertLees's Profile:
> http://www.excelforum.com/member.php...o&userid=26580
> View this thread: http://www.excelforum.com/showthread...hreadid=401072
>

[William]

Hi Robert

=IF(OR(A1=5,A1=10),"Its 5 or 10","")

--


XL2003
Regards

William
[email protected]


"RobertLees" <[email protected]> wrote
in message news:[email protected]...
>
> Hi
>
> How can I test 2 criteria to set a cell value? I think there is an
> =if(or---etc, but what syntax should I use.
>
> Thanks
> Robert
>
>
> --
> RobertLees
> ------------------------------------------------------------------------
> RobertLees's Profile:
> http://www.excelforum.com/member.php...o&userid=26580
> View this thread: http://www.excelforum.com/showthread...hreadid=401072
>

[William]

Hi Robert

=IF(OR(A1=5,A1=10),"Its 5 or 10","")

--


XL2003
Regards

William
[email protected]


"RobertLees" <[email protected]> wrote
in message news:[email protected]...
>
> Hi
>
> How can I test 2 criteria to set a cell value? I think there is an
> =if(or---etc, but what syntax should I use.
>
> Thanks
> Robert
>
>
> --
> RobertLees
> ------------------------------------------------------------------------
> RobertLees's Profile:
> http://www.excelforum.com/member.php...o&userid=26580
> View this thread: http://www.excelforum.com/showthread...hreadid=401072
>

[William]

Hi Robert

=IF(OR(A1=5,A1=10),"Its 5 or 10","")

--


XL2003
Regards

William
[email protected]


"RobertLees" <[email protected]> wrote
in message news:[email protected]...
>
> Hi
>
> How can I test 2 criteria to set a cell value? I think there is an
> =if(or---etc, but what syntax should I use.
>
> Thanks
> Robert
>
>
> --
> RobertLees
> ------------------------------------------------------------------------
> RobertLees's Profile:
> http://www.excelforum.com/member.php...o&userid=26580
> View this thread: http://www.excelforum.com/showthread...hreadid=401072
>

[William]

Hi Robert

=IF(OR(A1=5,A1=10),"Its 5 or 10","")

--


XL2003
Regards

William
[email protected]


"RobertLees" <[email protected]> wrote
in message news:[email protected]...
>
> Hi
>
> How can I test 2 criteria to set a cell value? I think there is an
> =if(or---etc, but what syntax should I use.
>
> Thanks
> Robert
>
>
> --
> RobertLees
> ------------------------------------------------------------------------
> RobertLees's Profile:
> http://www.excelforum.com/member.php...o&userid=26580
> View this thread: http://www.excelforum.com/showthread...hreadid=401072
>

[William]

Hi Robert

=IF(OR(A1=5,A1=10),"Its 5 or 10","")

--


XL2003
Regards

William
[email protected]


"RobertLees" <[email protected]> wrote
in message news:[email protected]...
>
> Hi
>
> How can I test 2 criteria to set a cell value? I think there is an
> =if(or---etc, but what syntax should I use.
>
> Thanks
> Robert
>
>
> --
> RobertLees
> ------------------------------------------------------------------------
> RobertLees's Profile:
> http://www.excelforum.com/member.php...o&userid=26580
> View this thread: http://www.excelforum.com/showthread...hreadid=401072
>