Limit Formula to 2 decimal places

Thanks:  0
Likes:  0

# Thread: Limit Formula to 2 decimal places

1. ## Limit Formula to 2 decimal places

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.

2. With a simpler example:

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

3. 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")))

4. 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.

5. Formula
=NewGP-OldGP

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

6.
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

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•