Remember Me?

#1
December 6th 04, 05:37 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.

#2
December 6th 04, 05:42 PM
 Paul B Posts: n/a

Barb, here is one way
=IF(ISBLANK(S69),"Void","")
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Barb123" wrote in message
...
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.

#3
December 6th 04, 05:44 PM
 Frank Kabel Posts: n/a

=IF(S69="",
or
=IF(ISBLANK(S69),

--
Regards
Frank Kabel
Frankfurt, Germany

Barb123 wrote:
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.

#4
December 6th 04, 05:50 PM
 Myrna Larson Posts: n/a

=IF(ISBLANK(S69,"Void",...)
=IF(S69="","Void",...)

On Mon, 6 Dec 2004 09:37:09 -0800, "Barb123"
wrote:

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.

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

 Similar Threads Thread Thread Starter Forum Replies Last Post TREK5200 Excel Discussion (Misc queries) 1 December 6th 04 02:23 AM Rich Excel Discussion (Misc queries) 2 December 4th 04 05:44 PM GRITS Excel Discussion (Misc queries) 1 December 2nd 04 08:30 PM Binki55_CanYouHearMeNow Excel Discussion (Misc queries) 1 November 30th 04 06:08 PM ??????????? Excel Discussion (Misc queries) 1 November 26th 04 04:03 PM

All times are GMT +1. The time now is 05:32 AM.