View Single Post
  #3   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

Hi Gary
Thanks for this, alas it didn't work :( the answer I get is 2 decimal
places out i.e. 4.14875 as opposed to 414.875 and has "E+12" on the end.....?
Mel

"Gary" wrote:

Try this

=(((B3+C3+D3)*(E3))*(F3))

let me know if it works.

Thanks
Gary

"Mel B" <Mel wrote in message
...
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