| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Formula
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with Formula
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with Formula
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with Formula
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with Formula
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with Formula
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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with Formula
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. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
