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 |
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 |
All times are GMT +1. The time now is 02:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com