Thread: Rookie Alert-
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.setup
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Rookie Alert-

.. in B2 as "=B1*.3"

Yes, of course, but that would simply be hardcoding it. Usually, it's better
to illustrate by having the formula pointing to a cell (eg B1 in the earlier
example) so that we can easily adjust/change the percentage in that one cell
to another value (if we need to), without having to edit and re-fill the
formulas down col B.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---