View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mel B Mel B is offline
external usenet poster
 
Posts: 5
Default multiple function in formula

Thanks Ron. I've just spoken with the person I'm doing this formula
for....and he's given me the totally wrong information! ARGH!!! thanks for
your help anyway :)

"Ron Rosenfeld" wrote:

On Mon, 17 Jul 2006 02:48:01 -0700, Mel B <Mel
wrote:

Hey guys
How can I make the following formula work =(B3+C3+D3)*E3*F3? I need the
numbers in brackets to be multiplied by E3 and then that number multiplied by
F3, what am I doing wrong?
Thanks
Mel


Give some sample data, expected and actual results.

For example =(1+2+3)*4*5 -- 120

What result do you expect?


--ron