Help

Piece of IF formula not returning a result

Topic Labels: Formulas
Solved
Jump to Solution
550 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Christine_Ayres
4 - Data Explorer
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”)))
Screen Shot 2021-09-17 at 12.02.05 PM

1 Solution

Accepted Solutions
augmented
10 - Mercury
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.

See Solution in Thread

2 Replies 2
augmented
10 - Mercury
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.

That seems to have worked, thank you!