MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Lars: Repost your question "Return blank..."


Posted by Aladin Akyurek on November 06, 2001 10:41 AM

Maybe you're looking for:

=IF(ISBLANK(A1), "", return-something-else)

is the usual formula most tend to use.

I often use:

=IF(LEN(A1)=0 ,"", return-something-else)


Posted by Lars on November 06, 2001 10:57 AM

Reposted - where can I put the Len in there

Here is my formula

=IF(SUM($B$1:B1)>1410000,B1*1.8,IF(SUM($B$1:B1)>1100000,B1*1.65,IF(SUM($B$1:B1)>0,B1*1.5,"")))

Posted by Aladin Akyurek on November 06, 2001 11:20 AM

Re: Reposted - where can I put the Len in there

=IF(LEN(B1),IF(SUM($B$1:B1)>1410000,B1*1.8,IF(SUM($B$1:B1)>1100000,B1*1.65,IF(SUM($B$1:B1)>0,B1*1.5,""))),"")

Aladin

=========

Posted by Lars on November 06, 2001 12:04 PM

Re: Reposted - where can I put the Len in there