Thanks:  0
Likes:  0

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

1. 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??

2. 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. 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. 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

#### Posting Permissions

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