J
JAD
I would like to format a cell that will either show the
value as "LF" or as a quantity using the "(xx)" format.
Although the following IF statement is in a modified
format, the idea should be understandable to what I am
trying to do.
IF( G1 = "x", format cell Q1 as "lf", else format
as "(xx)" )
Intended Results: If the user enters an x in cell G1,
format the inputted number with the letters "lf" for
linear feet. If the user does not enter an x in cell G1,
format the inputted number with "( )" designating a
quantity around the value.
value as "LF" or as a quantity using the "(xx)" format.
Although the following IF statement is in a modified
format, the idea should be understandable to what I am
trying to do.
IF( G1 = "x", format cell Q1 as "lf", else format
as "(xx)" )
Intended Results: If the user enters an x in cell G1,
format the inputted number with the letters "lf" for
linear feet. If the user does not enter an x in cell G1,
format the inputted number with "( )" designating a
quantity around the value.