LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 21
Default using a conditional suffix in text function format syntax=text(value,format_text)

I can employ this number format

[=1]# "month";[1]# "months"

so that if I enter
1
in a cell it will display : 1 month
but if I enter
2
it will display : 2 months.

what I want to do is use that same format as part of the Text function
(I'll eventually be employing it as part of a concatenated string).

i.e. =TEXT(A1,"[=1]# "month";[1]# "months"")

but the problem is obviously that using quotes to signify the text
suffix, is throwing out the syntax for the function.

I can get round it the long way using IFs, but it's clunky. Is there
some secret excel guru juice that will help me out?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel---how do i automate adding a suffix to text? Peter-NYC Excel Discussion (Misc queries) 1 January 29th 08 05:21 PM
What is the syntax for function text parameters in VBA (Excel 07) Jocken Excel Worksheet Functions 4 August 1st 07 08:47 PM
Help with sorting numbers with text suffix Jackson Excel Discussion (Misc queries) 2 April 11th 07 02:28 AM
conditional format for text Todd Excel Worksheet Functions 3 July 19th 06 09:12 PM
Sorting when some numbers have a text suffix confused on the tundra Excel Discussion (Misc queries) 5 December 18th 04 10:19 PM


All times are GMT +1. The time now is 11:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"