| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ISBLANK 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 -- - Zilla (Remove XSPAM) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISBLANK function???
B1=if(OR(ISBLANK(A1), A1=0), "", some_value)
How about this: =IF(OR(A1="",A1=0),"",some_value) Biff "Zilla" wrote in message ... 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 -- - Zilla (Remove XSPAM) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISBLANK function???
Duh for me! That was simple enough, thanks!
"T. Valko" wrote in message ... B1=if(OR(ISBLANK(A1), A1=0), "", some_value) How about this: =IF(OR(A1="",A1=0),"",some_value) Biff "Zilla" wrote in message ... 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 -- - Zilla (Remove XSPAM) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISBLANK function???
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 "Zilla" wrote in message ... Duh for me! That was simple enough, thanks! "T. Valko" wrote in message ... B1=if(OR(ISBLANK(A1), A1=0), "", some_value) How about this: =IF(OR(A1="",A1=0),"",some_value) Biff "Zilla" wrote in message ... 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 -- - Zilla (Remove XSPAM) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| isBlank() | Excel Worksheet Functions | |||
| ISBLANK() function | New Users to Excel | |||
| ISBLANK | Excel Worksheet Functions | |||
| isblank function | Excel Worksheet Functions | |||
| Is there a function for "not isblank" (find a cell that has a val. | Excel Worksheet Functions | |||
![Zilla[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
