I'm trying to keep a cell blank for the False component of an IF statement.
If I leave it blank it comes back with False in the cell. I don't want
anything in the False section of the IF statement. How do I do that?
I'm trying to keep a cell blank for the False component of an IF statement.
If I leave it blank it comes back with False in the cell. I don't want
anything in the False section of the IF statement. How do I do that?
Put: "" as the value_if_false in the IF
Example: =IF(expression, value_if_true , "")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"ruthslaughter" <[email protected]> wrote in message
news:[email protected]...
> I'm trying to keep a cell blank for the False component of an IF
statement.
> If I leave it blank it comes back with False in the cell. I don't want
> anything in the False section of the IF statement. How do I do that?
If the cell evaluates to "" and then shows blank, but, another cell
references the blank cell that second cell returns a #VALUE. Its OK if
the cell evaluates to a number but not "". Is there a way around this?
Thanks
Max wrote:
> Put: "" as the value_if_false in the IF
> Example: =IF(expression, value_if_true , "")
> --
> Rgds
> Max
> xl 97
> ---
> Singapore, GMT+8
> xdemechanik
> http://savefile.com/projects/236895
> --
> "ruthslaughter" <[email protected]> wrote in message
> news:[email protected]...
>
>>I'm trying to keep a cell blank for the False component of an IF
>
> statement.
>
>>If I leave it blank it comes back with False in the cell. I don't want
>>anything in the False section of the IF statement. How do I do that?
>
>
>
Post the formula that returns the value error, a value error occurs when you
calculate with text like "" so you can replace it with 0 instead if you add
it or you can use functions that ignores text like SUM or SUMIF
--
Regards,
Peo Sjoblom
(No private emails please)
"noyb" <[email protected]> wrote in message
news:[email protected]...
> If the cell evaluates to "" and then shows blank, but, another cell
> references the blank cell that second cell returns a #VALUE. Its OK if the
> cell evaluates to a number but not "". Is there a way around this?
> Thanks
>
> Max wrote:
>> Put: "" as the value_if_false in the IF
>> Example: =IF(expression, value_if_true , "")
>> --
>> Rgds
>> Max
>> xl 97
>> ---
>> Singapore, GMT+8
>> xdemechanik
>> http://savefile.com/projects/236895
>> --
>> "ruthslaughter" <[email protected]> wrote in
>> message
>> news:[email protected]...
>>
>>>I'm trying to keep a cell blank for the False component of an IF
>>
>> statement.
>>
>>>If I leave it blank it comes back with False in the cell. I don't want
>>>anything in the False section of the IF statement. How do I do that?
>>
>>
As Peo mentioned (Thanks, Peo !),
we could use: =IF(expression, value_if_true , 0) instead
to avoid downstream calc issues.
And to achieve a clean look, if desired, we could switch off
the display of "extraneous" zeros in the sheet via:
Tools > Options > View tab > Uncheck "Zero values" > OK
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
Thanks, I did not realize that =sum(a1,b1) when a1 = "" would not return
#VALUE.
Peo Sjoblom wrote:
> Post the formula that returns the value error, a value error occurs when
> you calculate with text like "" so you can replace it with 0 instead if
> you add it or you can use functions that ignores text like SUM or SUMIF
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks