Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 22nd 06, 04:44 PM posted to microsoft.public.excel.misc
GRL
 
Posts: n/a
Default Leaving an empty cell empty

Using an "IF" formula, I need to leave empty the empty cells (I mean, cells
containing nothing). I tried many ways, f.e., putting a "" if the formula
finds and empty cell, but Excel (2003) puts something all the times.
Thanks to all.
Giovanni



  #2   Report Post  
Old April 22nd 06, 04:51 PM posted to microsoft.public.excel.misc
Doug Kanter
 
Posts: n/a
Default Leaving an empty cell empty

"GRL" wrote in message
...
Using an "IF" formula, I need to leave empty the empty cells (I mean,
cells containing nothing). I tried many ways, f.e., putting a "" if the
formula finds and empty cell, but Excel (2003) puts something all the
times.
Thanks to all.
Giovanni


Look at this formula:
=IF($A14=0,"",$A14*G14)

See the two commas in the middle, surrounding the double quotation marks? Do
you have something like that in your formula?


  #3   Report Post  
Old April 22nd 06, 05:10 PM posted to microsoft.public.excel.misc
Ardus Petus
 
Posts: n/a
Default Leaving an empty cell empty

=IF(A1="","",IF(A1=1,0,1))

HTH
--
AP

"GRL" a écrit dans le message de
...

"Doug Kanter" ha scritto nel messaggio
...
"GRL" wrote in message
...
Using an "IF" formula, I need to leave empty the empty cells (I mean,
cells containing nothing). I tried many ways, f.e., putting a "" if

the
formula finds and empty cell, but Excel (2003) puts something all the
times.
Thanks to all.
Giovanni


Look at this formula:
=IF($A14=0,"",$A14*G14)

See the two commas in the middle, surrounding the double quotation

marks?
Do you have something like that in your formula?

Thank you, but my problem is a little more complex: I have a column with

all
the cells containing only "1" or "0" or being empty. I need to reverse

the
"1"'s into "0"'s, and vice versa, and to leave the empty cells as they

are.
I'm not able to find how to do it.
Giovanni




  #4   Report Post  
Old April 22nd 06, 05:30 PM posted to microsoft.public.excel.misc
Doug Kanter
 
Posts: n/a
Default Leaving an empty cell empty


"GRL" wrote in message
...

"Doug Kanter" ha scritto nel messaggio
...
"GRL" wrote in message
...
Using an "IF" formula, I need to leave empty the empty cells (I mean,
cells containing nothing). I tried many ways, f.e., putting a "" if the
formula finds and empty cell, but Excel (2003) puts something all the
times.
Thanks to all.
Giovanni


Look at this formula:
=IF($A14=0,"",$A14*G14)

See the two commas in the middle, surrounding the double quotation marks?
Do you have something like that in your formula?

Thank you, but my problem is a little more complex: I have a column with
all the cells containing only "1" or "0" or being empty. I need to
reverse the "1"'s into "0"'s, and vice versa, and to leave the empty cells
as they are. I'm not able to find how to do it.
Giovanni


Except for the problem with empty cells, does your formula work otherwise?
If yes, please post the formula here.


  #5   Report Post  
Old April 22nd 06, 05:47 PM posted to microsoft.public.excel.misc
GRL
 
Posts: n/a
Default Leaving an empty cell empty

This is the solution!
Thank you, Ardus, and thank you all.
Giovanni
"Ardus Petus" ha scritto nel messaggio
...
=IF(A1="","",IF(A1=1,0,1))

HTH
--
AP

"GRL" a écrit dans le message de
...

"Doug Kanter" ha scritto nel messaggio
...
"GRL" wrote in message
...
Using an "IF" formula, I need to leave empty the empty cells (I mean,
cells containing nothing). I tried many ways, f.e., putting a "" if

the
formula finds and empty cell, but Excel (2003) puts something all the
times.
Thanks to all.
Giovanni


Look at this formula:
=IF($A14=0,"",$A14*G14)

See the two commas in the middle, surrounding the double quotation

marks?
Do you have something like that in your formula?

Thank you, but my problem is a little more complex: I have a column with

all
the cells containing only "1" or "0" or being empty. I need to reverse

the
"1"'s into "0"'s, and vice versa, and to leave the empty cells as they

are.
I'm not able to find how to do it.
Giovanni








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM
Blank (empty) cell always equal to 0?? ulfah Excel Discussion (Misc queries) 3 February 1st 06 04:55 PM
How do I set a cell to "Empty" so that it does not display in a ch Ian Charts and Charting in Excel 3 January 7th 05 01:12 AM
make a cell empty based on condition mpierre Charts and Charting in Excel 2 December 29th 04 01:01 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 11:55 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright ©2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017