Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting with IF Statement
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting with IF Statement
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 "JAD" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting with if statement | Excel Discussion (Misc queries) | |||
CONDITIONAL FORMATTING OR AN 'IF' STATEMENT? | Excel Discussion (Misc queries) | |||
Formatting Cells using an If Statement | Excel Worksheet Functions | |||
If Statement/Conditional Formatting | Excel Worksheet Functions | |||
How do I check formatting in an if-then statement | Excel Worksheet Functions |