topic Re: IF/Else formula - how to return a blank cell in Discussions

IF/Else formula - how to return a blank cell

JSledz289 — Tue, 13 Feb 2024 14:43:59 GMT

I am creating an conditional formula. If the condition I am evaluating is false, How do I return a blank cell?

If( :Orientation == "X", :"X Ave"n / 100, ??)

I want to evaluate a column and if it is "X" then I want to perform an equation. If it is any other value I want to return a blank cell.

What do use in the "else" part of the formula to return a blank cell?

mmarchandTSI — Tue, 13 Feb 2024 15:10:23 GMT

Since it's a character column, use "".

If( :Orientation == "X", :"X Ave"n / 100, "")

Thierry_S — Tue, 13 Feb 2024 15:38:35 GMT

Hi,

If your column type is numeric, you can use the following syntax because the solution provided is geared toward a character type column:

if(:Orientation == "X", :"X ave"n / 100, .)

The empty value is represented by a single period.

Best,

JSledz289 — Wed, 14 Feb 2024 20:26:09 GMT

Thank You @Thierry_S . The resulting column is numeric therefore " " does not work. Adding the single period worked perfectly.