Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula
I'm using this formula.
=IF(C2="","",SUMIF('Part Number'!A:A,A2,'Part Number'!B:B)) I need the results from this formula to show me a % of that number. Example: Whatever number shows up in this formula is 100%. divide that number by the number in cell c2 to give the actual percentage rate. I've tried adding a /c2 sign at the end if this but I'm not getting an actual percentage. The cell is already formatted as a percentage. Thanks in advance!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula
If I understand correctly, try this
=IF(C2="","",(SUMIF('Part Number'!A:A,A2,'Part Number'!B:B)/C2)) Mike "Richard" wrote: I'm using this formula. =IF(C2="","",SUMIF('Part Number'!A:A,A2,'Part Number'!B:B)) I need the results from this formula to show me a % of that number. Example: Whatever number shows up in this formula is 100%. divide that number by the number in cell c2 to give the actual percentage rate. I've tried adding a /c2 sign at the end if this but I'm not getting an actual percentage. The cell is already formatted as a percentage. Thanks in advance!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula
I've tried that but for some reason it doesn't work returning the correct
percentage. Example if the results in c2 and the results in d2 are the same it does return the correct percentage such as C2 = 24 and D2 = 24 it will return 100% but if the results in C2 = 12 and the results in D2 = 24 it returns 200% but it should return 50% Thanks for your help!!! "Mike H" wrote: If I understand correctly, try this =IF(C2="","",(SUMIF('Part Number'!A:A,A2,'Part Number'!B:B)/C2)) Mike "Richard" wrote: I'm using this formula. =IF(C2="","",SUMIF('Part Number'!A:A,A2,'Part Number'!B:B)) I need the results from this formula to show me a % of that number. Example: Whatever number shows up in this formula is 100%. divide that number by the number in cell c2 to give the actual percentage rate. I've tried adding a /c2 sign at the end if this but I'm not getting an actual percentage. The cell is already formatted as a percentage. Thanks in advance!!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula
Hi,
That's what I would expect but if you want it the other way around do it like this =IF(C2="","",(C2/SUMIF('Part Number'!A:A,A2,'Part Number'!B:B))) Mike "Richard" wrote: I've tried that but for some reason it doesn't work returning the correct percentage. Example if the results in c2 and the results in d2 are the same it does return the correct percentage such as C2 = 24 and D2 = 24 it will return 100% but if the results in C2 = 12 and the results in D2 = 24 it returns 200% but it should return 50% Thanks for your help!!! "Mike H" wrote: If I understand correctly, try this =IF(C2="","",(SUMIF('Part Number'!A:A,A2,'Part Number'!B:B)/C2)) Mike "Richard" wrote: I'm using this formula. =IF(C2="","",SUMIF('Part Number'!A:A,A2,'Part Number'!B:B)) I need the results from this formula to show me a % of that number. Example: Whatever number shows up in this formula is 100%. divide that number by the number in cell c2 to give the actual percentage rate. I've tried adding a /c2 sign at the end if this but I'm not getting an actual percentage. The cell is already formatted as a percentage. Thanks in advance!!! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula
Turn your division around. 24 truly is 200% of 12. That is, if C2=12 and
D2=24 and you do =D2/C2, the answer is 2 which is 200%. But if you did C2/D2 you'd get .5 or 50%. Sounds like the formula may need to be written as =IF(C2="","",C2/SUMIF('Part Number'!A:A,A2,'Part Number'!B:B)) You may need to make sure that the SUMIF() doesn't evaluate to zero to keep #DIV/0! errors from popping up. "Richard" wrote: I've tried that but for some reason it doesn't work returning the correct percentage. Example if the results in c2 and the results in d2 are the same it does return the correct percentage such as C2 = 24 and D2 = 24 it will return 100% but if the results in C2 = 12 and the results in D2 = 24 it returns 200% but it should return 50% Thanks for your help!!! "Mike H" wrote: If I understand correctly, try this =IF(C2="","",(SUMIF('Part Number'!A:A,A2,'Part Number'!B:B)/C2)) Mike "Richard" wrote: I'm using this formula. =IF(C2="","",SUMIF('Part Number'!A:A,A2,'Part Number'!B:B)) I need the results from this formula to show me a % of that number. Example: Whatever number shows up in this formula is 100%. divide that number by the number in cell c2 to give the actual percentage rate. I've tried adding a /c2 sign at the end if this but I'm not getting an actual percentage. The cell is already formatted as a percentage. Thanks in advance!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|