Two formated values in the same cell

two formated values in the same cell

Sometimes you need to insert two values into the same cell. Like having the profit variation in absolute terms and in percentages in a single cell. Different format for two values in a single cell The solution to this problem is the TEXT(value,format) formula. Imagine that you need to show the variance over two years…