Trying to get a text string along with a formula

Hi All,

I am trying to get a text string along with the formula to show up.

For example, Cell A1=10 and Cell B1=10, when we subtract A1-B1, the end result of the formula I need is, "0, No variance"

or

Cell A1=10 and Cell B1=8, when we subtract A1-B1, the end result of the formula I need is, "2, Variance"

I need the difference between the cells appearing along with the text string of variance if there is a difference or no variance if there is no difference between the two cells.

Appreciate the help and thanks in advance!

One way

Formula:

Please Login or Register  to view this content.

Welcome to the forum.

Try this:

=IF(A1-B1=0,"0, No Variance",A1-B1&”, Variance")

Alternatively, you can use a custom number format to put text in the cell while retaining the actual value for other calculations:

Please Login or Register  to view this content.

If you drag the cell with the formula/format, the format goes along. If you are doing copy/paste, just use paste special, formulas & number formats. I just tried it by copying to a new sheet...

You're welcome. Thanks for the rep.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.