Welcome!

Decimal

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

Formulas

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!

SumIF formula help
I am trying to find the right formula to use in the scenario if a cell in the row is yes, then it sums cells in the same row to create a total. threshold totalscore1 totalscore2 totalscore3 Final score yes 46 10 9 this would pull a total for the 3 total score cells in the row no 15 75 12 this cell would not total because…
Helper Formula for filtering contradicting Status
I can't quite get the filter to align with my intent. I'm either pulling every status when I want to exclude "Complete" tasks or I can't get parent rows for my project schedule. I want the attached report to do the following for ease of presentation past due AND upcoming activities. Status is one of Not Started or In…
Can I count cells between number thresholds if the cell also has text in it?
Hello! I'm currently creating formulas for a gift register to document the price ranges we have and how many are in each category. My categories are: £0 - £50 £50 - £100 £100 - £200 £200 + However, the formulas aren't pulling back all the data accurately because some of the cells include text too like 'less than £500' or…