Forum Discussion
Help using Nested IF formula in PERCENTILE
Hi,
I have a large data set, which contains many entities. I am looking to find the value of a percentile, using the percentile function on excel. To have the formula only select the entity and check in question i am looking to use the IF function. However i seem to not be able to get it to work.
My two criteria are to match the "entity code" & "validation" in columns A & B. Any help or insight on what i am doing incorrectly would be very much appreciated.
Kind regards,
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.
5 Replies
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.
