IF/Else formula - how to return a blank cell
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?