Hi
Libby,
To force a 0 to display after the decimal, you can use the
TEXT function to format the result of the
ROUND function. Here's an example:
- =TEXT(ROUND(C29*(92%),1),"0.0") & "-" & TEXT(ROUND(C29*(108%),1),"0.0")
In this formula, the
"0.0" format code tells Excel to display one digit after the decimal, and to display a 0 if there is no digit to display. The
"&" symbol is used to concatenate the two results with a hyphen in between.
If you have any macro or Visual Basic code, wrap it in the tags.