Try changing the format by right clicking on the cell.

or

can you tell me the numbers u have in B3,C3,D3,E3 AND F3?


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