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.

Maybe something along these lines:
=IF(AND(A80,A8<=4),(E8+2)*1.1,IF(AND(A84,A8<=10) ,(E8+4)*1.1,IF(AND(A810,A8<=25),(E8+6)*1.1,"")))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"lizzyp" wrote:
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.

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.

That worked great - just had to change the E in your formula below to A and
it did exactly what I wanted, thanks for your time & help.

"Max" wrote:

Maybe something along these lines:
=IF(AND(A80,A8<=4),(E8+2)*1.1,IF(AND(A84,A8<=10) ,(E8+4)*1.1,IF(AND(A810,A8<=25),(E8+6)*1.1,"")))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"lizzyp" wrote:
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.

Sorry about the mix up. Glad you got it sorted out ok <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"lizzyp" wrote:
That worked great - just had to change the E in your formula below to A and
it did exactly what I wanted, thanks for your time & help.

I wouldn't have without you giving me the foundation to do so, thanks again.

"Max" wrote:

Sorry about the mix up. Glad you got it sorted out ok <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"lizzyp" wrote:
That worked great - just had to change the E in your formula below to A and
it did exactly what I wanted, thanks for your time & help.

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.

Ahh, that's real nice of you there.
Your kind comments are fully appreciated by this responder.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
On Feb 26, 7:38 pm, lizzyp wrote:
I wouldn't have without you giving me the foundation to do so, thanks again.