Excel: "Cell not emply" question

Most of us are not "computer people" so post your technical questions and comments here. If you have computer or Internet expertise, share it here.

Moderators: carlson1, Keith B

Post Reply
User avatar

Topic author
Charles L. Cotton
Site Admin
Posts in topic: 2
Posts: 17787
Joined: Wed Dec 22, 2004 9:31 pm
Location: Friendswood, TX
Contact:

Excel: "Cell not emply" question

#1

Post by Charles L. Cotton »

I need to use an if/then function dealing with an empty cell, but nothing I try works. Here is what I need to do:

If(A1 [not emply], A1,"XXX")

Any suggestions folks?

Thanks,
Chas.
User avatar

92f-fan
Senior Member
Posts in topic: 1
Posts: 524
Joined: Mon Nov 02, 2009 4:08 pm
Location: Carrollton

Re: Excel: "Cell not emply" question

#2

Post by 92f-fan »

some details as to why you want to put xxx in an empty cell might help
for alternative solutions

ScooterSissy
Senior Member
Posts in topic: 1
Posts: 795
Joined: Thu Mar 15, 2012 1:23 pm

Re: Excel: "Cell not emply" question

#3

Post by ScooterSissy »

=IF(((A1)<>""),A1,"XXX")

Edit (I tend to get carried away with ()'s)
This will work too:
=IF((A1<>""),A1,"xxx")
User avatar

Topic author
Charles L. Cotton
Site Admin
Posts in topic: 2
Posts: 17787
Joined: Wed Dec 22, 2004 9:31 pm
Location: Friendswood, TX
Contact:

Re: Excel: "Cell not emply" question

#4

Post by Charles L. Cotton »

ScooterSissy wrote:=IF(((A1)<>""),A1,"XXX")

Edit (I tend to get carried away with ()'s)
This will work too:
=IF((A1<>""),A1,"xxx")
Thanks, that worked!

Chas.
Post Reply

Return to “Technical Tips, Questions & Discussions (Computers & Internet)”