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!

Anyone resolved 'automatically adding rows to a sheet based on a trigger value' ?
Hi Community Facing a problem many others have posted about, but haven't seen a solution yet and wondered if it had been solved. I want to be able to add a row on a resource sheet for each project resource once a project has been set to 'X' on a Projects sheet. I have tried through automations but the daisy-chain limit…
Check a box if date is in the past or in the 60 days
Hello! I have this formula that will check the box if the date in a second column is in the past. Is there a way to include if the date is 60 days in the future? Check the box if the date in Column 2 is either (1) in the past or (2) 60 days in the future. IF([GWO - BST (2yr)]@row < TODAY(), 1, 0) Thank you in advance!
Update Dropdown List
Is there a way to automatically update my dropdown list for a form if I have a new item added? I have a New Order Entry form. I have a dropdown list of customers, but if it is a new customer, there is a checkbox to allow more fields to open up to enter that information. If that information is added, it gets copied to a…