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. |
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 |
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 - |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 01:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com