| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Use quotation marks in a formula to display a qty in feet and inc.
=if(Price List!f12=0,"9' x 12" wall","9' x 8" wall") I'm trying to display
the 9' x 12" text, but it contains inches(") therefore I get an error message for using " as inches and " as an operator. Is there a substitute for the " operator? Thanks |
|
#2
|
|||
|
|||
|
Try:
=IF('Price List'!F12=0,"9' x 12"&CHAR(34)&" wall","9' x 8"&CHAR(34)&" wall") HTH Jason Atlanta, GA "Jose" wrote: =if(Price List!f12=0,"9' x 12" wall","9' x 8" wall") I'm trying to display the 9' x 12" text, but it contains inches(") therefore I get an error message for using " as inches and " as an operator. Is there a substitute for the " operator? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
| Modifying a Formula To display only Unique Values | Excel Worksheet Functions | |||
| Values won't display after altering a formula. | Excel Worksheet Functions | |||
| how do I display "meter square" symbol in a formula cell ? | Excel Worksheet Functions | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
Linear Mode
