hide the returned value "false" I have submerged zero values

Although I have submerged zero values, and hidden formulas, the cell still
displays "false" when the if statement has not been met. How can I have the
word "false" submerged.

Hi!

Use a return of zero in your IF function when the logical test is FALSE.

An alternative, use conditional formatting to hide them.

Conditional Formatting:
Cell value is: equal to: FALSE
Set the font color to be the same as the background color

Biff

"Ms Trish" <Ms [email protected]> wrote in message
news:[email protected]...
> Although I have submerged zero values, and hidden formulas, the cell still
> displays "false" when the if statement has not been met. How can I have
> the
> word "false" submerged.

Hi!

Use a return of zero in your IF function when the logical test is FALSE.

An alternative, use conditional formatting to hide them.

Conditional Formatting:
Cell value is: equal to: FALSE
Set the font color to be the same as the background color

Biff

"Ms Trish" <Ms [email protected]> wrote in message
news:[email protected]...
> Although I have submerged zero values, and hidden formulas, the cell still
> displays "false" when the if statement has not been met. How can I have
> the
> word "false" submerged.

Hi!

Use a return of zero in your IF function when the logical test is FALSE.

An alternative, use conditional formatting to hide them.

Conditional Formatting:
Cell value is: equal to: FALSE
Set the font color to be the same as the background color

Biff

"Ms Trish" <Ms [email protected]> wrote in message
news:[email protected]...
> Although I have submerged zero values, and hidden formulas, the cell still
> displays "false" when the if statement has not been met. How can I have
> the
> word "false" submerged.

=IF(A1=X,200,"")

meaning if the condition is not met return blank

adapt to fit

--
Regards,

Peo Sjoblom

(No private emails please)


"Ms Trish" <Ms [email protected]> wrote in message
news:[email protected]...
> Although I have submerged zero values, and hidden formulas, the cell still
> displays "false" when the if statement has not been met. How can I have
> the
> word "false" submerged.

=IF(A1=X,200,"")

meaning if the condition is not met return blank

adapt to fit

--
Regards,

Peo Sjoblom

(No private emails please)


"Ms Trish" <Ms [email protected]> wrote in message
news:[email protected]...
> Although I have submerged zero values, and hidden formulas, the cell still
> displays "false" when the if statement has not been met. How can I have
> the
> word "false" submerged.

=IF(A1=X,200,"")

meaning if the condition is not met return blank

adapt to fit

--
Regards,

Peo Sjoblom

(No private emails please)


"Ms Trish" <Ms [email protected]> wrote in message
news:[email protected]...
> Although I have submerged zero values, and hidden formulas, the cell still
> displays "false" when the if statement has not been met. How can I have
> the
> word "false" submerged.

Hi!

Use a return of zero in your IF function when the logical test is FALSE.

An alternative, use conditional formatting to hide them.

Conditional Formatting:
Cell value is: equal to: FALSE
Set the font color to be the same as the background color

Biff

"Ms Trish" <Ms [email protected]> wrote in message
news:[email protected]...
> Although I have submerged zero values, and hidden formulas, the cell still
> displays "false" when the if statement has not been met. How can I have
> the
> word "false" submerged.

=IF(A1=X,200,"")

meaning if the condition is not met return blank

adapt to fit

--
Regards,

Peo Sjoblom

(No private emails please)


"Ms Trish" <Ms [email protected]> wrote in message
news:[email protected]...
> Although I have submerged zero values, and hidden formulas, the cell still
> displays "false" when the if statement has not been met. How can I have
> the
> word "false" submerged.