| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
