View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brotherharry Brotherharry is offline
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?