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.
Excel: "Cell not emply" question
-
Topic author - Site Admin
- Posts in topic: 2
- Posts: 17787
- Joined: Wed Dec 22, 2004 9:31 pm
- Location: Friendswood, TX
- Contact:
-
- Senior Member
- Posts in topic: 1
- Posts: 524
- Joined: Mon Nov 02, 2009 4:08 pm
- Location: Carrollton
Re: Excel: "Cell not emply" question
some details as to why you want to put xxx in an empty cell might help
for alternative solutions
for alternative solutions
-
- Senior Member
- Posts in topic: 1
- Posts: 795
- Joined: Thu Mar 15, 2012 1:23 pm
Re: Excel: "Cell not emply" question
=IF(((A1)<>""),A1,"XXX")
Edit (I tend to get carried away with ()'s)
This will work too:
=IF((A1<>""),A1,"xxx")
Edit (I tend to get carried away with ()'s)
This will work too:
=IF((A1<>""),A1,"xxx")
-
Topic author - 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
Thanks, that worked!ScooterSissy wrote:=IF(((A1)<>""),A1,"XXX")
Edit (I tend to get carried away with ()'s)
This will work too:
=IF((A1<>""),A1,"xxx")
Chas.