I need a holiday....!!!
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: I need a holiday....!!!

  1. #1
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    All, I'm being the slowest person today,

    I have a formula:

    =IF(LEN(A102)>0,IF(A102+1<=MAX(Listing!B:B),Breakdown!A102+1,""),"")

    Which will return a blank IF the number above is <= the max on a sheet AND also return a blank if the one above has no text in.

    The formula is so I can extend beyond the range required, so it will fill when the Listings sheet expands.

    There's probably a lot of way to do this, the problem I'm having is understanding why:

    =IF(or(LEN(A102)>0,A102+1<=MAX(Listing!B:B)),Breakdown!A102+1,"")

    doesn't do the same job??
    "Have a good time......all the time"
    Ian Mac

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Which will return a blank IF the number above is <= the max on a sheet AND also return a blank if the one above has no text in.

    IF the number above is <= the max on a sheet AND also return a blank if the one above has no text in.

    IF the number above is <= the max
    AND
    if the one above has no text in.

    IF(AND





  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,868
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    On 2002-03-28 03:03, Ian Mac wrote:
    All, I'm being the slowest person today,

    I have a formula:

    =IF(LEN(A102)>0,IF(A102+1<=MAX(Listing!B:B),Breakdown!A102+1,""),"")

    Which will return a blank IF the number above is <= the max on a sheet AND also return a blank if the one above has no text in.

    The formula is so I can extend beyond the range required, so it will fill when the Listings sheet expands.

    There's probably a lot of way to do this, the problem I'm having is understanding why:

    =IF(or(LEN(A102)>0,A102+1<=MAX(Listing!B:B)),Breakdown!A102+1,"")

    doesn't do the same job??
    Replace OR by AND. Is that what you're after?

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I don't even want to tell you both how utterly stupid I feel!!!!!!!!!

    deeply ashamed!!!
    _________________
    Share the wealth!!
    Ian Mac

    [ This Message was edited by: Ian Mac on 2002-03-28 09:09 ]

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