Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 17, 2021 12:06 PM
I am having trouble with the second IF part of this formula, it doesn’t return any results. I also tried it on it’s own and it still doesn’t return a result.
IF({Writer Owned (adds up to 100%)}=.33330, VALUE(“16.66”), IF({Writer Owned (adds up to 100%)}=.33340, VALUE(“16.68”)))
Solved! Go to Solution.
Sep 17, 2021 01:19 PM
Hi Christine. Dealing with floating point numbers (numbers with decimals) can sometimes be squirrely. I don’t know what’s going on here, I tried replicating your issue and was able to. However, there are some things you should change about your formula. First, you don’t need to use VALUE(number string). You should just use the number (e.g. 16.68). Second, the only way I could get what you wanted was to use the FLOOR function.
IF({Writer Owned (adds up to 100%)}=0.3333, 16.66, IF(FLOOR({Writer Owned (adds up to 100%)}, 0.00001)=0.3334, 16.68))
Let us know if that works for you.
Sep 17, 2021 01:19 PM
Hi Christine. Dealing with floating point numbers (numbers with decimals) can sometimes be squirrely. I don’t know what’s going on here, I tried replicating your issue and was able to. However, there are some things you should change about your formula. First, you don’t need to use VALUE(number string). You should just use the number (e.g. 16.68). Second, the only way I could get what you wanted was to use the FLOOR function.
IF({Writer Owned (adds up to 100%)}=0.3333, 16.66, IF(FLOOR({Writer Owned (adds up to 100%)}, 0.00001)=0.3334, 16.68))
Let us know if that works for you.
Sep 17, 2021 01:27 PM
That seems to have worked, thank you!