I need a holiday....!!!

Ian Mac · Mar 28th, 2002, 04:03 AM

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 · Mar 28th, 2002, 07:08 AM

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 · Mar 28th, 2002, 09:30 AM

Quote:

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 · Mar 28th, 2002, 10:08 AM

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 ]

Mar 28th, 2002, 04:03 AM	#1
Ian Mac MrExcel MVP Join Date: Feb 2002 Location: Newcastle, UK Posts: 1,174	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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 28th, 2002, 07:08 AM	#2
IML MrExcel MVP Join Date: Feb 2002 Location: Denver, CO Posts: 1,744	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

Mar 28th, 2002, 10:08 AM	#4
Ian Mac MrExcel MVP Join Date: Feb 2002 Location: Newcastle, UK Posts: 1,174	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 ]