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
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
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" <[email protected]> wrote in message news:[email protected]...
> 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
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
[email protected]
"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
Sorry I left out a paren, don't see how you got anything out of it at all
A17: -300
B17: 0.00
C17 =IF(ISBLANK(A17),"====",A17-B17) [-- displays -300 --]
---
"gudway" <[email protected]> wrote in message news:[email protected]...
> 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
> [email protected]
>
>
>
>
> "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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks