I Have a LEN Question

Mykro

Active Member
This Newbie to Excel would like to know how the LEN function works in this example...
=IF(LEN(D11),IF(D11+C11<F11,"LOST","WON"),"")
This message was edited by Mykro on 2002-11-01 10:57

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

lenze

Legend
Edit your post and disable html

Juan Pablo González

MrExcel MVP
Excel undertands the FALSE boolean as 0, and TRUE as any number different than 0. So, if the cell D11 has anything in it, the LEN() formula makes Excel calculate the TRUE part of the IF...

MrExcel MVP
On 2002-11-01 10:52, Mykro wrote:
This Newbie to Excel would like to know how the LEN function works in this example...
=IF(LEN(D11),IF(D11+C11<F11,"LOST","WON"),"")

A wild guess...

=IF(COUNTBLANK(C11:D1),"",IF(SUM(C11:D11)<F11,"LOST","WON"))

is probably what you are looking for?
This message was edited by Aladin Akyurek on 2002-11-01 12:39

Mykro

Active Member
Juan, I've noticed that without the "")
on the end of the function it returns ####
When there is no data entered and just using a regular "if" statement without the LEN function with no data entered it returns it as false or "won". So, in order to have it return with it blank,the statement needs to have the LEN funtion with "") at the end..
Correct ??
This message was edited by Mykro on 2002-11-01 16:48

Replies
2
Views
100
Replies
7
Views
186
Replies
26
Views
577
Replies
1
Views
244
Replies
1
Views
352

1,127,798
Messages
5,626,941
Members
416,209
Latest member
tan21

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back