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
Steven


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...

=$A2/$B$1

Copy thie formula down the length of column A.