 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / February 2007ISBLANK function???
Say I have this 1 2 A f1 f2 B ? ? How do I leave B1 and B2 blank if their corresponding f1 and f2 functions in A1 and A2 respectively are either 0 or blank. Again in psedo-code A1=(if(blah), some_value, "") B1=if(OR(ISBLANK(A1), A1=0), "", some_value) Similar for A2/B2  Signature- Zilla (Remove XSPAM) >B1=if(OR(ISBLANK(A1), A1=0), "", some_value) How about this: =IF(OR(A1="",A1=0),"",some_value) Biff > Say I have this > [quoted text clipped - 10 lines] > > Similar for A2/B2 Duh for me! That was simple enough, thanks! > >B1=if(OR(ISBLANK(A1), A1=0), "", some_value) > [quoted text clipped - 18 lines] > > > > Similar for A2/B2 Well, that ISBLANK function is incorrectly named! It should be named ISEMPTY. Just about everyone considers a formula blank ="" a blank cell (not an empty cell) cell but ISBLANK doesn't. Biff > Duh for me! That was simple enough, thanks! > [quoted text clipped - 20 lines] >> > >> > Similar for A2/B2 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.