Limit Formula to 2 decimal places

[erock24]

Hi I am using this formula to return a value and a label

=IF(NewGP-OldGP=0,"No Change",IF(NewGP-OldGP>0,NewGP-OldGP&" Increase",IF(NewGP-OldGP<0,NewGP-OldGP&" Decrease")))

value = NewGP-OldGP and where the formula is bolded I only need the standard 2 decimal format. I've tried, but failed.

thank you for your time and help.

 

[VoG]

With a simpler example:

=TEXT(A1,"0.00") & " label"

 

[konew1]

Hi
Try this
=IF(NewGP-OldGP=0,"No Change",IF(NewGP-OldGP>0,Text(NewGP-OldGP,"#.00")&" Increase",IF(NewGP-OldGP<0,TEXT(NewGP-OldGP,"0.00")&" Decrease")))

 

[konew1]

Or you could format the cell to be:
#,##0.00 Increase;-#,##0.00 Decrease
Which has the advantage that it is still numeric and you can do further calculations from the result.

 

[Scott Huish]

Formula
=NewGP-OldGP

and format as
#,##0.00 "Increase";-#,##0.00 "Decrease";"No Change"

 

[erock24]

thank you all for the help.

I adjusted the formula with this concept because for my application it was the best fit.

Text(NewGP-OldGP,"0.00")

works great