| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
concatenate formula result with text ?
This is my pseudocode. Two question actually: 1) how can I concatenate the
following? --(B5/B3) * 100 is numeric -- add text to this result? (B50,(B5/B3)*100 & " % increase", (B5/B3) * 100 & " % decrease) 2) how to eliminate trailing decimals and only have a whole number from (B5/B3) * 100? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
concatenate formula result with text ?
I was having a syntax error. Here is a formula that works for both questions:
=IF(B5=0,"",IF(B50,INT(ABS((B5/B3)*100)) & " % increase", INT(ABS((B5/B3)*100)) & " % decrease") & " since last year.") "Rich" wrote: This is my pseudocode. Two question actually: 1) how can I concatenate the following? --(B5/B3) * 100 is numeric -- add text to this result? (B50,(B5/B3)*100 & " % increase", (B5/B3) * 100 & " % decrease) 2) how to eliminate trailing decimals and only have a whole number from (B5/B3) * 100? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to concatenate text into a formula? | Excel Discussion (Misc queries) | |||
| Formula needed to concatenate text with result from calculation | Excel Discussion (Misc queries) | |||
| Concatenate text cell and formula cell result | Excel Worksheet Functions | |||
| Why does Concatenate formula show but not produce a cell result? | Excel Worksheet Functions | |||
| CONCATENATE text formula | Excel Worksheet Functions | |||
Linear Mode
