Posted to microsoft.public.excel.worksheet.functions

Zilla[_2_] Zilla[_2_] is offline

external usenet poster

Posts: 51

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)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
isBlank()	alex	Excel Worksheet Functions	6	February 8th 07 10:33 PM
ISBLANK() function	George	New Users to Excel	1	July 14th 06 08:40 AM
ISBLANK	Gimpy815	Excel Worksheet Functions	2	February 24th 06 06:09 PM
isblank function	Brian	Excel Worksheet Functions	8	December 12th 04 01:35 PM
Is there a function for "not isblank" (find a cell that has a val.	Jim	Excel Worksheet Functions	3	December 8th 04 07:29 AM

All times are GMT +1. The time now is 09:49 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us