View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Help with Formula

Yes, but you can lose the SUM() function.

Where the OP was asking for =sum(A8+2)*1.1, =(A8+2)*1.1 would have done the
job.
--
David Biddulph

"macropod" wrote in message
...
Hi lizzyp,

Perhaps something along the lines of:
=SUM(A8+(1+(A84)+(A810)+(A825))*2)*1.1

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"lizzyp" wrote in message
...
I need to create a formula as follows: If A8<=4 then E8=sum(A8+2)*1.1 or
if A84<=10 then E8=sum(A8+4)*1.1 or if A810<=25 then E8=sum(A8+6)*1.1
etc.