Show "+" (plus) sign when comparing two values
Try
=IF(B1-A10,"+"&B1-A1,B1-A1)
--
Regards
Warren
Excel Novice
Addiewell, Scotland.
If this helps please click the Yes button.
"filpass" wrote:
Dear Excel experts,
I am comparing the values of cells in two columns: if difference B1-A1 is
<0, then the minus sign logically appears before the value.
But how can I make a "+" sign appear when difference B1-A1 0?
A thousand of thanks for your help!
|