Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 16th 05, 02:15 PM
mbrockhaus
 
Posts: n/a
Default How do I set a result of an "if" function to NULL; not 0 or ""?

I'm using an "if" statement and I want to set the TRUE condition results to
NULL rather than "0" or "". Is there a way to do this?

  #3   Report Post  
Old May 16th 05, 03:08 PM
bj
 
Posts: n/a
Default

What do you mean by "NULL"?
and why don't you want ""?

"mbrockhaus" wrote:

I'm using an "if" statement and I want to set the TRUE condition results to
NULL rather than "0" or "". Is there a way to do this?

  #4   Report Post  
Old May 16th 05, 05:03 PM
mbrockhaus
 
Posts: n/a
Default

Did that. I need to concatentate the results and so, if something "failed"
the if check, I need the results to be NULL (or blank), without Excel
thinking something is really in the cell (like a space; even "" seems to not
be the same thing). I think I really need a WHEN function more than an IF.

"Don Guillett" wrote:

Do you mean
=if(a1=2,"",4)

--
Don Guillett
SalesAid Software

"mbrockhaus" wrote in message
...
I'm using an "if" statement and I want to set the TRUE condition results

to
NULL rather than "0" or "". Is there a way to do this?




  #5   Report Post  
Old May 16th 05, 05:20 PM
mbrockhaus
 
Posts: n/a
Default

I need to concatentate the results and so, if something "failed" the if
check, I need the results to be NULL (or blank), without Excel thinking
something is really in the cell (like a space; even "" seems to not be the
same thing). Probably need something like a WHEN more than an IF.

"bj" wrote:

What do you mean by "NULL"?
and why don't you want ""?

"mbrockhaus" wrote:

I'm using an "if" statement and I want to set the TRUE condition results to
NULL rather than "0" or "". Is there a way to do this?



  #6   Report Post  
Old May 16th 05, 06:59 PM
bj
 
Posts: n/a
Default

You will need to have a macro to do this.
You cannot have a Blank in a cell as the result of an equation in that cell.
the macro which would be needed, depends on how the data is organized.

there are ways to get around the concatination of blank cells depending on
what you want to do.

"mbrockhaus" wrote:

I need to concatentate the results and so, if something "failed" the if
check, I need the results to be NULL (or blank), without Excel thinking
something is really in the cell (like a space; even "" seems to not be the
same thing). Probably need something like a WHEN more than an IF.

"bj" wrote:

What do you mean by "NULL"?
and why don't you want ""?

"mbrockhaus" wrote:

I'm using an "if" statement and I want to set the TRUE condition results to
NULL rather than "0" or "". Is there a way to do this?



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
convert value in word. For Exampe Rs.115.00 convert into word as . Shakti Excel Discussion (Misc queries) 1 May 10th 05 12:00 PM
How can i change this VBA project According to Indian Numeric Rao Ratan Singh Excel Discussion (Misc queries) 1 April 21st 05 07:53 PM
Amount or Numbers in Words ron New Users to Excel 6 December 24th 04 07:32 PM
Is there a formula to spell out a number in excel? Sha-nay-nay Excel Worksheet Functions 2 December 18th 04 09:25 PM
Convert Numeric into Text Monty Excel Worksheet Functions 0 December 18th 04 09:25 PM


All times are GMT +1. The time now is 12:00 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