Excel公式可将文本/单词添加到百分比结果 [英] Excel Formula to add text/word to a percentage result

问题描述

我在1个单元格中有一个公式

I have a formula in 1 cell

=(A6-B6)/B6

在单元格C6中结果为-0.105243123560658. A6具有新的销售额，而B6具有旧的销售额.我正在尝试将结果格式化为:

Which results to -0.105243123560658in cell C6. A6 has the new sales amount and B6 has the old sales amount. I'm trying to get the result formatted like:

Difference is 10%

我有2个问题

• 如何将小数转换为非小数(我已经对此进行了研究)
• 如何在计算结果中添加文本/单词，例如将"Difference is "添加到(A6-B6)/B6计算结果.

• How to get the decimals turn into non-decimal number (I'm already researching on this)
• How to add a text/word to a calculation result like adding "Difference is " to the (A6-B6)/B6 calculation result.

我已尝试研究此问题，而我能找到的唯一解决方案涉及使用其他单元格.有没有办法只使用1个单元格($ C $ 6)来做到这一点?我尝试过

This I have tried to research and the only solution I can find involves using additional cells. Is there a way to do this with using only 1 cell ($C$6)? I tried

="Difference is "&(A6-B6)/B6

，但是我得到的是Difference is -0.105243123560658.还尝试过:

but I'm getting Difference is -0.105243123560658 instead. Also tried:

="Difference is "&($B$6-$C$6)/ABS($C$6)

推荐答案

您需要TEXT函数:

="Difference is "&TEXT(ABS(A6-B6)/B6,"0%")

这篇关于Excel公式可将文本/单词添加到百分比结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！