I need a holiday....!!!

[Ian Mac]

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

 

[IML]

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

 

[Aladin Akyurek]

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?

 

[Ian Mac]

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