Forum Discussion
Help using Nested IF formula in PERCENTILE
calof1 I altered the formula quite a bit and it has become a monster. The sheet calculates very slow (at least, on my machine) so I set it to calculate manually. Then, there isn't much data in column E. Only the first 193 rows out of 86000 contain a number. Only two rows in the Proposed Tolerance sheet (rows 335 and 336) return a numeric result. I trust that your real data set has more numbers in it.
calof1 I altered the formula quite a bit and it has become a monster. The sheet calculates very slow (at least, on my machine) so I set it to calculate manually. Then, there isn't much data in column E. Only the first 193 rows out of 86000 contain a number. Only two rows in the Proposed Tolerance sheet (rows 335 and 336) return a numeric result. I trust that your real data set has more numbers in it.
Hi Riny,
Thank you kindly for your assistance. From your comments i noticed i needed to copy down my formula in column E, so now it has the full set. I did notice that when i did this, i no longer have the results for row 335 and 336. To run the formula, i just pressed calculate now. Is there an additional step i need to do?
Many thanks for your assistance.
Kind regards,calof1 You're welcome! With regard to sheet calculation, you can set it back to Auto. I just switched it off s it became to slow on my machine, at least.
- Thanks i have turned back on. I have noticed all the calculations show "-". However the formula works for some rows when the data in column E was less. Does this mean the size of the data is too big to calculate?
