View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default excel function within a function

=(A1*A2)/A1

or just
=A2 since A1 will cancel out.

--
Regards,
Tom Ogilvy

"Lrobison" wrote in message
...
I need to divide the product of a set of cells by the data in one of the

cells used to find product. For example, the product of A1 and A2 divided
by A1. Can anyone help? Thanks.