ExcelBanter - ISBLANK function???

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - ISBLANK function??? (https://www.excelbanter.com/excel-worksheet-functions/131797-isblank-function.html)

Zilla[_2_]

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)

T. Valko

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)

Zilla[_2_]

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)

T. Valko

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)

All times are GMT +1. The time now is 08:26 AM.