Hank Isaacs
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're most welcome.
Glad to help.
Alan.
Glad to help.
Alan.
ASKER