Forum Discussion
Solved
Showing two Values in single cell (+/- change)
This seems like an easy fix or maybe not but i just cant figure it out. I am trying to show the %, Amount, or $ change from one cell to another. While retaining the current Value. For Exampl...
You cannot do this in B1 itself.
I'd create a formula in column C. In C1:
=TEXT(B1, "$0")& " (" & TEXT(B1-A1, "+$0;-$0") &")"
This can be filled down. You can use a similar format for cells with a general number or a percentage, but you'll have to create a separate formula for each of those.
You cannot do this in B1 itself.
I'd create a formula in column C. In C1:
=TEXT(B1, "$0")& " (" & TEXT(B1-A1, "+$0;-$0") &")"
This can be filled down. You can use a similar format for cells with a general number or a percentage, but you'll have to create a separate formula for each of those.
OH! this is exactly what i want, i can pull the B1 and A1 data from else. i.e. create the formula in a hidden cell and c/p it to the cell i desire! Thank you so much!
One extra thing, is there a fix for the decimal point? ill have to just show you what i mean i think
D21 : $21,741.97 E21: $24,469.80
you formula shows $24470 (+$2755)
This is exactly what i was trying to do, but id like to so the original $24,469.80 instead of the 24,470.
One extra thing, is there a fix for the decimal point? ill have to just show you what i mean i think
D21 : $21,741.97 E21: $24,469.80
you formula shows $24470 (+$2755)
This is exactly what i was trying to do, but id like to so the original $24,469.80 instead of the 24,470.
- AH! "$0.00"
Thanks again for the response, very helpfulEven better, to display thousands separators too:
=TEXT(B1, "$#,##0.00")& " (" & TEXT(B1-A1, "+$#,##0.00;-$#,##0.00") &")"