IF function
Upcoming Power Excel Seminars
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: IF function

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Canada
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi

    I am having a problem. I need the following If formula to work for me.

    The scenerio: A building having a GFA greater than 250 and less than 1500 must have its parking measured at 1 space/28m2.

    Therefore I need the following function (which I have apparantly not written the right syntax for)
    F20 is the final GFA cell

    If(2501500, F20/G27,"") This works for GFA area over 250m2, however it doesnt shut off when I reach 1500m2 floor area. I have another cell that does the over 1500m2 calculation so I need this one to blank out after 1500m2. Sorry if this is confusing. I hope you understand what I'm trying to explain.

    Thanks for any help
    Larry (Big_guy)

  2. #2
    Board Regular eliW's Avatar
    Join Date
    Mar 2002
    Posts
    1,919
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-23 22:15, Big_guy wrote:
    Hi

    I am having a problem. I need the following If formula to work for me.

    The scenerio: A building having a GFA greater than 250 and less than 1500 must have its parking measured at 1 space/28m2.

    Therefore I need the following function (which I have apparantly not written the right syntax for)
    F20 is the final GFA cell

    If(2501500, F20/G27,"") This works for GFA area over 250m2, however it doesnt shut off when I reach 1500m2 floor area. I have another cell that does the over 1500m2 calculation so I need this one to blank out after 1500m2. Sorry if this is confusing. I hope you understand what I'm trying to explain.

    Thanks for any help
    Larry (Big_guy)
    Larry, try this:
    =IF(AND(F20>250,F20<1500),F20/G27,"")
    Eli

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Canada
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks so much for your help Eli. I was trying to get that to work for 3 hours last night. Man I really appreciate you assistance Everything is working perfectly now.

    Take care.

    Larry

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com