Thread
:
Expression
View Single Post
#
3
Posted to microsoft.public.excel.newusers
gudway
Posts: n/a
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 With Quote