MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Dynamic Numerator...Static Denominator

Posted by Steven on February 07, 2002 11:12 AM

If anyone can help.....

I need to make it possible to take many cells in a column and divide each cell (individualy) with one cell in another column (a constant). I am not sure what the syntax is to make a division problem have a dynamic numerator and a static denominator.

Thank you for your time

Posted by Mark W. on February 07, 2002 11:16 AM

If you numerators are in column A and the denominator
is in cel B1 you can use...


Copy thie formula down the length of column A.