If, Then sttement

milkbonemom · Jun 4, 2008

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 · Jun 4, 2008

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

Jim Thomlinson · Jun 4, 2008

Perhaps this...

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

milkbonemom · Jun 4, 2008

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

Jim Thomlinson said:
Perhaps this...

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

PCLIVE · Jun 4, 2008

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

Regards,
Paul

--

Dave Peterson · Jun 4, 2008

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

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

Regards,
Paul

Excel Concatenate with line breaks but ignore blank cells	3	Feb 23, 2019
Leave Blank If No Data	6	Apr 26, 2010
Is that possible. More than on If Formula	2	Mar 28, 2010
If then statement	3	Jan 28, 2010
Is that possible; More than one Formula	3	Mar 28, 2010
If Formula to Identify Cell	1	Mar 28, 2010
Help with a Formula	3	May 7, 2009
Macro to add numbers in a text string	5	Dec 5, 2014

If, Then sttement

milkbonemom

PCLIVE

Jim Thomlinson

milkbonemom

PCLIVE

Dave Peterson

Ask a Question

Similar Threads