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
Tags:
Comments

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?

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

Not an inconvenience at all! 2 sets of eyes are better than one! Glad I could help you out!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!