Positive sign

  • Thread starter Thread starter richard.woollacott
  • Start date Start date
R

richard.woollacott

Can anyone help please?
In a group of cells containing calculated figures, I would like positive
numbers to be preceded with the + sign. Can anyone tell me how to do it. I
suspect that the text command is what I want, but I cannot find a way of
adding it to the section after the ,

The formula I am using is :
=IF(C15=B15,"On Budget",(C15-B15)/B15*100)
 
Hi Richard
one way: Apply the following custom format to this cell (goto 'Format -
Cells'):
+#,##0.00;-#,##0.00 ;0.00
 
Back
Top