Excel TEXT Function

Should be easy.

I want a text message to appear when G13=0

=IF(G13=0,"Delete Line Item Weight "&$E13&" in cell E13 then Rebalance Remaining Category Items to 100%","")    Cell E13 equals 5%.

The text message that appears now is "Delete Line Item Weight 0.05 in cell E13 then Rebalance Remaining Category Items to 100%"

I would like the text message to say 5% instead of 0.05.


Thank you.
Hank IsaacsEngineerAsked:
Who is Participating?
 
AlanConsultantCommented:
Hi,

Try this:

=IF(G13=0,"Delete Line Item Weight "&Text($E$13,"0%")&" in cell E13 then Rebalance Remaining Category Items to 100%","")

Open in new window


If you want the percentage to have more than one decimal place, say 2dp, then you could use this:

=IF(G13=0,"Delete Line Item Weight "&Text($E$13,"0.00%")&" in cell E13 then Rebalance Remaining Category Items to 100%","")

Open in new window



Alan.
0
 
Hank IsaacsEngineerAuthor Commented:
Perfect - Thank you very much.
0
 
AlanConsultantCommented:
You're most welcome.

Glad to help.

Alan.
0
All Courses

From novice to tech pro — start learning today.