If, Then sttement

[milkbonemom]

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.

 

[PCLIVE]

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

 

[Jim Thomlinson]

Perhaps this...

=if(trim(d328) = "", "", "add")

 

[milkbonemom]

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

Perhaps this...

=if(trim(d328) = "", "", "add")

 

[David Biddulph]

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

 

[PCLIVE]

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

Regards,
Paul

--

 

[Dave Peterson]

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

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

Regards,
Paul