View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default Divide Column A by Column B multiply Column C

The advantage of having the formulas in cols B and C point to "fixed" cells
(i.e. B1 and C1), instead of hardcoding the values: 65 and 0.07 directly
into the formulas, is that we don't have to amend all the formulas should
the values(constants) need to be changed in future. We'd just simply change
the values in B1 and C1.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--