# Piece of IF formula not returning a result

Topic Labels: Formulas
Solved
234 2
cancel
Showing results for
Did you mean:  4 - Data Explorer

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”))) 1 Solution

Accepted Solutions  10 - Mercury

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.

2 Replies 2  10 - Mercury

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.  4 - Data Explorer

That seems to have worked, thank you! 