-Excel Formula Question

Discussion in 'Computer Support' started by Katherine Colby, Jan 12, 2004.

  1. I'm trying to create an IF state like the one below to specify a
    number "Between 0 & 180". Here is the formula that is incorrect. Can
    anyone show me the correct syntax for the formula?

    What I'm trying to say is"

    If H3-C3 is greater than 0, but less than 180, L3-G3, otherwise leave
    the cell blank.

    =IF((H3-C3),>0&<180,(L3-G3)," ")

    Thanks!
    Katherine Colby, Jan 12, 2004
    #1
    1. Advertising

  2. Katherine Colby

    Brian H¹© Guest

    Katherine Colby said:

    > I'm trying to create an IF state like the one below to specify a
    > number "Between 0 & 180". Here is the formula that is incorrect. Can
    > anyone show me the correct syntax for the formula?
    >
    > What I'm trying to say is"
    >
    > If H3-C3 is greater than 0, but less than 180, L3-G3, otherwise leave
    > the cell blank.
    >
    > =IF((H3-C3),>0&<180,(L3-G3)," ")
    >
    > Thanks!


    If Excel was "intelligent", Lieutenant Commander Data would have been named
    Sub-Ensign ( ensign/standard ;-) ) Info.
    Brian H¹©, Jan 12, 2004
    #2
    1. Advertising

  3. > I'm trying to create an IF state like the one below to specify a
    > number "Between 0 & 180".
    >
    > If H3-C3 is greater than 0, but less than 180, L3-G3, otherwise leave
    > the cell blank.


    =IF((H3-C3)<180 AND (H3-C3)>0;(L3-G3);"")
    Alexander Rogge, Jan 12, 2004
    #3
  4. Katherine Colby

    Guest

    On Mon, 12 Jan 2004 02:35:19 GMT, Katherine Colby <>
    wrote:

    >=IF((H3-C3),>0&<180,(L3-G3)," ")


    The & is only used for connecting pieces of text.

    The correct formula should be:

    =IF(AND(H3-C3>0,H3-C3<180),(L3-G3)," ")

    Hope this helps

    regards
    Marcus
    , Jan 12, 2004
    #4
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Doug

    Excel 2003 Formula

    Doug, Feb 15, 2004, in forum: Microsoft Certification
    Replies:
    0
    Views:
    537
  2. =?Utf-8?B?QyBBbmRlcnNvbg==?=

    Excel Formula

    =?Utf-8?B?QyBBbmRlcnNvbg==?=, Apr 12, 2006, in forum: Microsoft Certification
    Replies:
    1
    Views:
    554
    Carey Frisch [MVP]
    Apr 12, 2006
  3. Max Sand

    Excel formula for this...

    Max Sand, Sep 2, 2003, in forum: Computer Support
    Replies:
    6
    Views:
    631
  4. sunny

    Simple Excel formula required

    sunny, Jan 6, 2004, in forum: Computer Support
    Replies:
    4
    Views:
    668
  5. VertiCody

    Excel Formula Question

    VertiCody, Oct 27, 2008, in forum: Microsoft Certification
    Replies:
    0
    Views:
    469
    VertiCody
    Oct 27, 2008
Loading...

Share This Page