Visual Cues to display number or text instead of color.

[retko1985]

Hello,

I want to display 0 if number in straight table is negative. And I don't want to rewrite my expression with if conditions, since its already complex. Is here a way, probably with visual cues as written in the title or any other way.

Thank you.

[RonaldDoes]

Hi Retko,

Usage of visual cues is strictly limited to the formatting of the cell value (color, font weight, size etc).

A simple:

=If(YOUR_EXPRESSION < 0, 0, YOUR_EXPRESSION)

should do the trick, however.

With kind regards,

Ronald

[retko1985]

Hi, I am already using if condition like this:

if(variable1 = 1, expression1, expression2)

I need for those both expressions to have 0 if it is negative. Can you help me please rewrite the condition?

Thank you.

[RonaldDoes · Accepted solution]

Hi Retko,

You can nest If-conditions, so:

=If(
If(variable1 = 1, expression1, expression2) < 0,
0, 
If(variable1 = 1, expression1, expression2)
)

should work like a charm!

[retko1985]

This is great, thank you.