| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If - then help.
this one is too complicated for my brain, so I need help... I'll do my best
to explain: I have 4 cells (A1, A2, A3, A4) A1 is a total dollar amount of a small section of a group of amounts A2 is a grand total dollar amount of the entire sheet before any percentage discounts are applied. A3 is a percentage of discount that will be applied to A2. A4 is a calculation resulting in 2% of A2 (A2*.02) A5 is the total after all discounts are applied. So here's the rub: I need to subtract A4 from A5 only if A1 is greater than or equal to A4. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If - then help.
this one is too complicated for my brain, so I need help... I'll do my
best to explain: I have 4 cells (A1, A2, A3, A4) A1 is a total dollar amount of a small section of a group of amounts A2 is a grand total dollar amount of the entire sheet before any percentage discounts are applied. A3 is a percentage of discount that will be applied to A2. A4 is a calculation resulting in 2% of A2 (A2*.02) A5 is the total after all discounts are applied. So here's the rub: I need to subtract A4 from A5 only if A1 is greater than or equal to A4. You seem to be describing this... =IF(A1=A4,A5-A4,"") Am I missing something? Rick |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If - then help.
Reading between the lines, the OP probably meant this:
=IF(A1=A4,A5-A4,A5) which, of course, could also be written: =A5-(A1=A4)*A4 Hope this helps. Pete On Jul 12, 5:31 pm, "Rick Rothstein \(MVP - VB\)" wrote: this one is too complicated for my brain, so I need help... I'll do my best to explain: I have 4 cells (A1, A2, A3, A4) A1 is a total dollar amount of a small section of a group of amounts A2 is a grand total dollar amount of the entire sheet before any percentage discounts are applied. A3 is a percentage of discount that will be applied to A2. A4 is a calculation resulting in 2% of A2 (A2*.02) A5 is the total after all discounts are applied. So here's the rub: I need to subtract A4 from A5 only if A1 is greater than or equal to A4. You seem to be describing this... =IF(A1=A4,A5-A4,"") Am I missing something? Rick- Hide quoted text - - Show quoted text - |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If - then help.
I probably didn't complete the discription. A5 need to be a total of
everything, so it is 'A5=(A2-(A2*A3)) this is without consideration of the equation I'm trying to address, so my problem lies with putting the above equation into one that accomplishes what you responded with. Would it be something like this: 'A5=(A2-(A2*A3)-(A4IF(A1=A4)) "Rick Rothstein (MVP - VB)" wrote: this one is too complicated for my brain, so I need help... I'll do my best to explain: I have 4 cells (A1, A2, A3, A4) A1 is a total dollar amount of a small section of a group of amounts A2 is a grand total dollar amount of the entire sheet before any percentage discounts are applied. A3 is a percentage of discount that will be applied to A2. A4 is a calculation resulting in 2% of A2 (A2*.02) A5 is the total after all discounts are applied. So here's the rub: I need to subtract A4 from A5 only if A1 is greater than or equal to A4. You seem to be describing this... =IF(A1=A4,A5-A4,"") Am I missing something? Rick |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If - then help.
Is this what you are looking for?
=A2-(A2*A3)-IF(A1=A4,A4,0) Rick "Roger" wrote in message ... I probably didn't complete the discription. A5 need to be a total of everything, so it is 'A5=(A2-(A2*A3)) this is without consideration of the equation I'm trying to address, so my problem lies with putting the above equation into one that accomplishes what you responded with. Would it be something like this: 'A5=(A2-(A2*A3)-(A4IF(A1=A4)) "Rick Rothstein (MVP - VB)" wrote: this one is too complicated for my brain, so I need help... I'll do my best to explain: I have 4 cells (A1, A2, A3, A4) A1 is a total dollar amount of a small section of a group of amounts A2 is a grand total dollar amount of the entire sheet before any percentage discounts are applied. A3 is a percentage of discount that will be applied to A2. A4 is a calculation resulting in 2% of A2 (A2*.02) A5 is the total after all discounts are applied. So here's the rub: I need to subtract A4 from A5 only if A1 is greater than or equal to A4. You seem to be describing this... =IF(A1=A4,A5-A4,"") Am I missing something? Rick |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If - then help.
=A2-(A2*A3)-(A1=A4)*A4
=A2*(1-A3)-(A1=A4)*A4 "Roger" wrote: I probably didn't complete the discription. A5 need to be a total of everything, so it is 'A5=(A2-(A2*A3)) this is without consideration of the equation I'm trying to address, so my problem lies with putting the above equation into one that accomplishes what you responded with. Would it be something like this: 'A5=(A2-(A2*A3)-(A4IF(A1=A4)) "Rick Rothstein (MVP - VB)" wrote: this one is too complicated for my brain, so I need help... I'll do my best to explain: I have 4 cells (A1, A2, A3, A4) A1 is a total dollar amount of a small section of a group of amounts A2 is a grand total dollar amount of the entire sheet before any percentage discounts are applied. A3 is a percentage of discount that will be applied to A2. A4 is a calculation resulting in 2% of A2 (A2*.02) A5 is the total after all discounts are applied. So here's the rub: I need to subtract A4 from A5 only if A1 is greater than or equal to A4. You seem to be describing this... =IF(A1=A4,A5-A4,"") Am I missing something? Rick |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If - then help.
Close.. I had to do this to make it work =A2-(A2*A3)-IF(A1=A4,(A1-A4),0)
thanks for all your help!!!! "Rick Rothstein (MVP - VB)" wrote: Is this what you are looking for? =A2-(A2*A3)-IF(A1=A4,A4,0) Rick "Roger" wrote in message ... I probably didn't complete the discription. A5 need to be a total of everything, so it is 'A5=(A2-(A2*A3)) this is without consideration of the equation I'm trying to address, so my problem lies with putting the above equation into one that accomplishes what you responded with. Would it be something like this: 'A5=(A2-(A2*A3)-(A4IF(A1=A4)) "Rick Rothstein (MVP - VB)" wrote: this one is too complicated for my brain, so I need help... I'll do my best to explain: I have 4 cells (A1, A2, A3, A4) A1 is a total dollar amount of a small section of a group of amounts A2 is a grand total dollar amount of the entire sheet before any percentage discounts are applied. A3 is a percentage of discount that will be applied to A2. A4 is a calculation resulting in 2% of A2 (A2*.02) A5 is the total after all discounts are applied. So here's the rub: I need to subtract A4 from A5 only if A1 is greater than or equal to A4. You seem to be describing this... =IF(A1=A4,A5-A4,"") Am I missing something? Rick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
