In cell N5 (which I have formatted to percentage and have tried 2 and 6 decimal places), there is currently 4.71%.
I have tried the ROUNDDOWN function two ways, in the formula for that cell and in a totally unrelated cell. I have tried rounding down to 1 and 2 decimal places, but keeping getting 0,00% as a result.
This is the formula I have in N5: =IFERROR((O5-$O$156),"")
With the ROUNDDOWN function, it looks like this: =IFERROR(ROUNDDOWN((O5-$O$156),1),"")
What I want, and expect, is for the result to be 4.70%
I have tried the ROUNDDOWN function two ways, in the formula for that cell and in a totally unrelated cell. I have tried rounding down to 1 and 2 decimal places, but keeping getting 0,00% as a result.
This is the formula I have in N5: =IFERROR((O5-$O$156),"")
With the ROUNDDOWN function, it looks like this: =IFERROR(ROUNDDOWN((O5-$O$156),1),"")
What I want, and expect, is for the result to be 4.70%
