Decimal

Tony Barthelemy

Good day All:

How do I get my formula to display in decimal format? My formula currently display 1 but should display 0.5.

[C5]14 = 7600

[C6] 14= 3800

Formula: =IF([C5]14 > 0, ([C6]14 / [C6]14))

 

Thanks

Mike Wilday

Hi Kam,

According to your formula, you are dividing the same field into itself. 

Any number divided by itself is 1. Perhaps one of the two references in the second part of your formula should be [C5]14?

Tony Barthelemy

You are absolutely right! It is amazing how we  miss the obvious. I made the change and have 0.5 displaying.

 

Thanks and sorry for the inconvenience 

Mike Wilday

Not an inconvenience at all! 2 sets of eyes are better than one! Glad I could help you out!