Number format question
A1 being the referenced cell, the formula would be written thus:
=CONCATENATE(text(A1*100,"0.0")," Basis Point",IF((a1*100)1,"s",""))
"BobK" wrote:
I am using Excel 2007. If I type .01 in a cell, I want the format to return
showing "1 Basis Point" (no quotes needed). If I type .035, I wish to have
the cell show "3.5 Basis Points". The plural/non plural would be nice, but
showing either would be fine.
Thanks!
|