ISNUMBER Function
I have opened up a worksheet that a coworker created last year and cannot
figure out the purpose of the isnumber function in this formula: {=SUM(N27:N117*P27:P117)/SUM(N27:N117*ISNUMBER(P27:P117))}. I have looked it up in Excel help and on Google with little insight. If anyone can please tell me what the purpose of this function is/does, it will be greatly appreciated. The data it is pulling from is all numbers. Regards, Jon |
ISNUMBER Function
It's either being used as an error checker or as a way to check for blanks.
For instance, if text appears in the P27:P117 range, it would normally cause the whole formula to fail. The isnumber function prevents that from happening, telling the denominator to ignore any number in N27:N117 that is associated with a nonnumber in the P range. Also, ISNUMBER returns a False for blank cells. So, the formula also excludes any N27:N117 number that is associated with a blank cell in the P range. Looking at the whole formula, this is what appears to be happening. He wants to divide by the sum of numbers in the N range that have a number in the P range. Hope that answers your question. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Jon" wrote: I have opened up a worksheet that a coworker created last year and cannot figure out the purpose of the isnumber function in this formula: {=SUM(N27:N117*P27:P117)/SUM(N27:N117*ISNUMBER(P27:P117))}. I have looked it up in Excel help and on Google with little insight. If anyone can please tell me what the purpose of this function is/does, it will be greatly appreciated. The data it is pulling from is all numbers. Regards, Jon |
ISNUMBER Function
THanks LUke.
That helped a lot. Cheers, Jon "Luke M" wrote: It's either being used as an error checker or as a way to check for blanks. For instance, if text appears in the P27:P117 range, it would normally cause the whole formula to fail. The isnumber function prevents that from happening, telling the denominator to ignore any number in N27:N117 that is associated with a nonnumber in the P range. Also, ISNUMBER returns a False for blank cells. So, the formula also excludes any N27:N117 number that is associated with a blank cell in the P range. Looking at the whole formula, this is what appears to be happening. He wants to divide by the sum of numbers in the N range that have a number in the P range. Hope that answers your question. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Jon" wrote: I have opened up a worksheet that a coworker created last year and cannot figure out the purpose of the isnumber function in this formula: {=SUM(N27:N117*P27:P117)/SUM(N27:N117*ISNUMBER(P27:P117))}. I have looked it up in Excel help and on Google with little insight. If anyone can please tell me what the purpose of this function is/does, it will be greatly appreciated. The data it is pulling from is all numbers. Regards, Jon |
All times are GMT +1. The time now is 04:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com