external usenet poster How do identify a blank cell... December 6th 04, 05:37 PM

external usenet poster Barb, here is one... December 6th 04, 05:42 PM

external usenet poster =IF(S69="", or =IF(I... December 6th 04, 05:44 PM

external usenet poster =IF(ISBLANK(S69,"Void&quo... December 6th 04, 05:50 PM

Barb123

Posts: n/a

How do identify a blank cell in a formula

Example: IF(s69=blank,"Void"....

What I want to say is if a cell, (s69in this example) is blank, enter the
word "Void"

but the above way don't work - I don't know how to enter that in this IF
formula.

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
Maintaining cell reference after sorting	GRITS	Excel Discussion (Misc queries)	2	April 30th 23 07:42 PM
cell reference in a formula is called	???????????	Excel Discussion (Misc queries)	2	April 22nd 23 09:02 AM
conditional formatting blank cell	TREK5200	Excel Discussion (Misc queries)	1	December 6th 04 02:23 AM
Aligning Two Lists in Excel	Rich	Excel Discussion (Misc queries)	2	December 4th 04 05:44 PM
Is there a way to transfer a style by cell referrence in a formula	Binki55_CanYouHearMeNow	Excel Discussion (Misc queries)	1	November 30th 04 06:08 PM

All times are GMT +1. The time now is 04:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us