Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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!!! |