If, Then sttement
 

I'm trying to get a result if something is not blank:
=IF(D328_is_not_blank,"add","")
The column will be text so if it is blank, I don't want anything returned as
a result.

If, Then sttement
 

=IF(D328<"","add","")

--

"milkbonemom" wrote in message
...
I'm trying to get a result if something is not blank:
=IF(D328_is_not_blank,"add","")
The column will be text so if it is blank, I don't want anything returned
as
a result.

If, Then sttement
 

Perhaps this...

=if(trim(d328) = "", "", "add")
--
HTH...

Jim Thomlinson


"milkbonemom" wrote:

I'm trying to get a result if something is not blank:
=IF(D328_is_not_blank,"add","")
The column will be text so if it is blank, I don't want anything returned as
a result.

If, Then sttement
 

Thanks. That works! what does "trim" mean?

"Jim Thomlinson" wrote:

Perhaps this...

=if(trim(d328) = "", "", "add")
--
HTH...

Jim Thomlinson


"milkbonemom" wrote:

I'm trying to get a result if something is not blank:
=IF(D328_is_not_blank,"add","")
The column will be text so if it is blank, I don't want anything returned as
a result.

If, Then sttement
 

TRIM is an Excel function, and is explained in Excel help (as are all other
Excel functions except one).
--
David Biddulph

"milkbonemom" wrote in message
...
Thanks. That works! what does "trim" mean?

"Jim Thomlinson" wrote:

Perhaps this...

=if(trim(d328) = "", "", "add")
--
HTH...

Jim Thomlinson


"milkbonemom" wrote:

I'm trying to get a result if something is not blank:
=IF(D328_is_not_blank,"add","")
The column will be text so if it is blank, I don't want anything
returned as
a result.

If, Then sttement
 

Ok, you've sparked my curiosity. Which function is not explained in help?

Regards,
Paul

--

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
TRIM is an Excel function, and is explained in Excel help (as are all
other Excel functions except one).
--
David Biddulph

"milkbonemom" wrote in message
...
Thanks. That works! what does "trim" mean?

"Jim Thomlinson" wrote:

Perhaps this...

=if(trim(d328) = "", "", "add")
--
HTH...

Jim Thomlinson


"milkbonemom" wrote:

I'm trying to get a result if something is not blank:
=IF(D328_is_not_blank,"add","")
The column will be text so if it is blank, I don't want anything
returned as
a result.

If, Then sttement
 

=datedif() was only documented in xl2k's help.

PCLIVE wrote:

Ok, you've sparked my curiosity. Which function is not explained in help?

Regards,
Paul

--

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
TRIM is an Excel function, and is explained in Excel help (as are all
other Excel functions except one).
--
David Biddulph

"milkbonemom" wrote in message
...
Thanks. That works! what does "trim" mean?

"Jim Thomlinson" wrote:

Perhaps this...

=if(trim(d328) = "", "", "add")
--
HTH...

Jim Thomlinson


"milkbonemom" wrote:

I'm trying to get a result if something is not blank:
=IF(D328_is_not_blank,"add","")
The column will be text so if it is blank, I don't want anything
returned as
a result.



--

Dave Peterson