| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Expression
In Lotus123 there is an expression like
@if(A17" ","Cell is NOT blank","Cell is blank") Please show how to co this with Excell ! Thanks |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Expression
Depending on what you really want
=IF(ISBLANK(A17, "Cell is blank", "Cell is NOT blank") =IF(TRIM(A17)="", "Treat as if Empty","Cell is NOT blank") However if the cell has a formula then it is not blank, if it has a space it is not blank, if it has a null string then it is not blank (meaning it is not empty). --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "gudway" wrote in message ... In Lotus123 there is an expression like @if(A17" ","Cell is NOT blank","Cell is blank") Please show how to co this with Excell ! Thanks |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Expression
Hello David
Thanks for your reply In C17 I placed =if(isblank(A17,"====",A17-B17) In A17 is -300.00 and in B17 is 0.00 I keep getting a positive result of 300 in C17 How can I fix this to get -300.00 in C17 Thanks "David McRitchie" wrote: Depending on what you really want =IF(ISBLANK(A17, "Cell is blank", "Cell is NOT blank") =IF(TRIM(A17)="", "Treat as if Empty","Cell is NOT blank") However if the cell has a formula then it is not blank, if it has a space it is not blank, if it has a null string then it is not blank (meaning it is not empty). --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Expression for Macro - help | Excel Discussion (Misc queries) | |||
| Excel expression {=SUm(if(istext(c8:k8),1,0))} | Excel Worksheet Functions | |||
| Can Excel represent formula in textural format with values substi. | Excel Worksheet Functions | |||
| > and < criteria in one single expression in excel | New Users to Excel | |||
| Excel Expression | Excel Discussion (Misc queries) | |||
Linear Mode
