Help with Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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,"")))
 
Hi lizzyp,

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

Cheers
 
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 said:
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]
-------------------------

lizzyp said:
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.
Click to expand...
Click to expand...
 
Ahh, that's real nice of you there.
Your kind comments are fully appreciated by this responder.
 
Back
Top