| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Show "2" only if....
I want the number "2" to appear before the result of V898.
="2"& " " &V898& " " &W898& " " &X898 If V898 does not contain data then return nothing. Anyone able to help with this? Much appreciate if you can. Pat |
|
#2
|
|||
|
|||
|
=IF(V898="","","2"&" " &V898& " " &W898& " " &X898)
-- HTH RP (remove nothere from the email address if mailing direct) "Pat" wrote in message ... I want the number "2" to appear before the result of V898. ="2"& " " &V898& " " &W898& " " &X898 If V898 does not contain data then return nothing. Anyone able to help with this? Much appreciate if you can. Pat |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show macro security setting in a cell | Excel Worksheet Functions | |||
| pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) | |||
| Long numbers show up as Scientific Notation | Excel Discussion (Misc queries) | |||
| UDF and Calculation tree | Links and Linking in Excel | |||
| Show a date based on today | Excel Worksheet Functions | |||
Linear Mode
