Help with Formula

[Guest]

I need to create a formula as follows: If A8<=4 then E8=sum(A8+2)*1.1 or if
A8>4<=10 then E8=sum(A8+4)*1.1 or if A8>10<=25 then E8=sum(A8+6)*1.1 etc.

 

[Guest]

Maybe something along these lines:
=IF(AND(A8>0,A8<=4),(E8+2)*1.1,IF(AND(A8>4,A8<=10),(E8+4)*1.1,IF(AND(A8>10,A8<=25),(E8+6)*1.1,"")))

 

[macropod]

Hi lizzyp,

Perhaps something along the lines of:
=SUM(A8+(1+(A8>4)+(A8>10)+(A8>25))*2)*1.1

Cheers

 

[Guest]

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.

 

[Guest]

Sorry about the mix up. Glad you got it sorted out ok <g>

 

[Guest]

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

 

[David Biddulph]

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

Hi lizzyp,

Perhaps something along the lines of:
=SUM(A8+(1+(A8>4)+(A8>10)+(A8>25))*2)*1.1

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

I need to create a formula as follows: If A8<=4 then E8=sum(A8+2)*1.1 or
if A8>4<=10 then E8=sum(A8+4)*1.1 or if A8>10<=25 then E8=sum(A8+6)*1.1
etc.

 

[Max]

Ahh, that's real nice of you there.
Your kind comments are fully appreciated by this responder.