Thread: multiple function in formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default multiple function in formula
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
Reply With QuoteReply With Quote