Formatting with IF Statement

  • Thread starter Thread starter JAD
  • Start date Start date
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.
 
You were almost there already. You aren't really trying to format as LF or
as (xx), you want that text to appear in the cell. therefore, just use
=IF(G1 = "x","lf","(xx)"). This assumes that you want to compare G1 to
some text that you will put within quotes, and you are not wanting "x" to be
a variable. For instance, =IF(G1 = "John","lf","(xx)") will yield "lf"
(without the quotes) if cell G1 says John (and you are not putting this
formula in G1). But if G1 is a number, then you would want to change your
formula to: =IF(G1 = 57,"lf","(xx)") . this assumes of course, that you
want lf in your formula cell if G1 is the number 57. Hopefully this makes
sense.
Richard Choate


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.
 
Back
Top