Just add formula in say E6

=IF(D6="","",$D6*$D$2)

and copy over.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

wrote in message
oups.com...
How can I fill a cell automatically when a different cell is changed?
For example, D2 contains a rate. When I enter data in any cell in
(d6:d19) I would the adjacent cell in (e6:e19) to be the value of the
cell in d*d2 (Same thing for range f6:f19 and g6:g19)

Thanks.