+ Reply to Thread
Results 1 to 26 of 26

If statement - 2 tests

Hybrid View

  1. 09-01-2005, 05:43 AM #1
    RobertLees
    RobertLees is offline
    Registered User
    Join Date
    08-24-2005
    Posts
    11

    If statement - 2 tests

    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
    Reply With QuoteRegister To Reply
  2. 09-01-2005, 07:05 AM #2
    William
    Guest

    Re: If statement - 2 tests

    Hi Robert

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

    --


    XL2003
    Regards

    William
    willwest22@yahoo.com


    "RobertLees" <RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com> wrote
    in message news:RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  3. 09-06-2005, 04:05 AM #3
    William
    Guest

    Re: If statement - 2 tests

    Hi Robert

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

    --


    XL2003
    Regards

    William
    willwest22@yahoo.com


    "RobertLees" <RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com> wrote
    in message news:RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  4. 09-05-2005, 10:05 PM #4
    William
    Guest

    Re: If statement - 2 tests

    Hi Robert

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

    --


    XL2003
    Regards

    William
    willwest22@yahoo.com


    "RobertLees" <RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com> wrote
    in message news:RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  5. 09-06-2005, 05:05 AM #5
    William
    Guest

    Re: If statement - 2 tests

    Hi Robert

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

    --


    XL2003
    Regards

    William
    willwest22@yahoo.com


    "RobertLees" <RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com> wrote
    in message news:RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  6. 09-05-2005, 11:05 PM #6
    William
    Guest

    Re: If statement - 2 tests

    Hi Robert

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

    --


    XL2003
    Regards

    William
    willwest22@yahoo.com


    "RobertLees" <RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com> wrote
    in message news:RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  7. 09-06-2005, 06:05 AM #7
    William
    Guest

    Re: If statement - 2 tests

    Hi Robert

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

    --


    XL2003
    Regards

    William
    willwest22@yahoo.com


    "RobertLees" <RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com> wrote
    in message news:RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  8. 09-06-2005, 08:05 AM #8
    William
    Guest

    Re: If statement - 2 tests

    Hi Robert

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

    --


    XL2003
    Regards

    William
    willwest22@yahoo.com


    "RobertLees" <RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com> wrote
    in message news:RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  9. 09-06-2005, 12:05 AM #9
    William
    Guest

    Re: If statement - 2 tests

    Hi Robert

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

    --


    XL2003
    Regards

    William
    willwest22@yahoo.com


    "RobertLees" <RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com> wrote
    in message news:RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  10. 09-06-2005, 01:05 AM #10
    William
    Guest

    Re: If statement - 2 tests

    Hi Robert

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

    --


    XL2003
    Regards

    William
    willwest22@yahoo.com


    "RobertLees" <RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com> wrote
    in message news:RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  11. 09-06-2005, 07:05 AM #11
    William
    Guest

    Re: If statement - 2 tests

    Hi Robert

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

    --


    XL2003
    Regards

    William
    willwest22@yahoo.com


    "RobertLees" <RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com> wrote
    in message news:RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  12. 09-06-2005, 09:05 AM #12
    William
    Guest

    Re: If statement - 2 tests

    Hi Robert

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

    --


    XL2003
    Regards

    William
    willwest22@yahoo.com


    "RobertLees" <RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com> wrote
    in message news:RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  13. 09-06-2005, 02:05 AM #13
    William
    Guest

    Re: If statement - 2 tests

    Hi Robert

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

    --


    XL2003
    Regards

    William
    willwest22@yahoo.com


    "RobertLees" <RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com> wrote
    in message news:RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  14. 09-06-2005, 11:05 AM #14
    William
    Guest

    Re: If statement - 2 tests

    Hi Robert

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

    --


    XL2003
    Regards

    William
    willwest22@yahoo.com


    "RobertLees" <RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com> wrote
    in message news:RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  15. 09-06-2005, 05:05 PM #15
    William
    Guest

    Re: If statement - 2 tests

    Hi Robert

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

    --


    XL2003
    Regards

    William
    willwest22@yahoo.com


    "RobertLees" <RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com> wrote
    in message news:RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  16. 09-06-2005, 04:05 PM #16
    William
    Guest

    Re: If statement - 2 tests

    Hi Robert

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

    --


    XL2003
    Regards

    William
    willwest22@yahoo.com


    "RobertLees" <RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com> wrote
    in message news:RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  17. 09-06-2005, 02:05 PM #17
    William
    Guest

    Re: If statement - 2 tests

    Hi Robert

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

    --


    XL2003
    Regards

    William
    willwest22@yahoo.com


    "RobertLees" <RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com> wrote
    in message news:RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  18. 09-06-2005, 08:05 PM #18
    William
    Guest

    Re: If statement - 2 tests

    Hi Robert

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

    --


    XL2003
    Regards

    William
    willwest22@yahoo.com


    "RobertLees" <RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com> wrote
    in message news:RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  19. 09-06-2005, 07:05 PM #19
    William
    Guest

    Re: If statement - 2 tests

    Hi Robert

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

    --


    XL2003
    Regards

    William
    willwest22@yahoo.com


    "RobertLees" <RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com> wrote
    in message news:RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  20. 09-06-2005, 06:05 PM #20
    William
    Guest

    Re: If statement - 2 tests

    Hi Robert

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

    --


    XL2003
    Regards

    William
    willwest22@yahoo.com


    "RobertLees" <RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com> wrote
    in message news:RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  21. 09-06-2005, 03:05 PM #21
    William
    Guest

    Re: If statement - 2 tests

    Hi Robert

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

    --


    XL2003
    Regards

    William
    willwest22@yahoo.com


    "RobertLees" <RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com> wrote
    in message news:RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  22. 09-06-2005, 03:05 AM #22
    William
    Guest

    Re: If statement - 2 tests

    Hi Robert

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

    --


    XL2003
    Regards

    William
    willwest22@yahoo.com


    "RobertLees" <RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com> wrote
    in message news:RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  23. 09-06-2005, 10:05 AM #23
    William
    Guest

    Re: If statement - 2 tests

    Hi Robert

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

    --


    XL2003
    Regards

    William
    willwest22@yahoo.com


    "RobertLees" <RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com> wrote
    in message news:RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  24. 09-06-2005, 09:05 PM #24
    William
    Guest

    Re: If statement - 2 tests

    Hi Robert

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

    --


    XL2003
    Regards

    William
    willwest22@yahoo.com


    "RobertLees" <RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com> wrote
    in message news:RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  25. 09-06-2005, 12:05 PM #25
    William
    Guest

    Re: If statement - 2 tests

    Hi Robert

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

    --


    XL2003
    Regards

    William
    willwest22@yahoo.com


    "RobertLees" <RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com> wrote
    in message news:RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  26. 09-07-2005, 12:05 AM #26
    William
    Guest

    Re: If statement - 2 tests

    Hi Robert

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

    --


    XL2003
    Regards

    William
    willwest22@yahoo.com


    "RobertLees" <RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com> wrote
    in message news:RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1