Dear Friends,
Working in a workbook where there are multiple if conditions:
Sheet1
<colgroup><col style="WIDTH: 30px; FONT-WEIGHT: bold"><col style="WIDTH: 176px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 108px"><col style="WIDTH: 95px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody>
</tbody>
If Type is D, & Days are in between (-) to 90 Days, then Rebate will be 0.5% of Gross value.
If Type is D, & Days are in between 91 to 180 Days, then Rebate will be 0.25% of Gross value.
If Type is D, & Days are more than 180 then Rebate will be 0.
If Type is blank & Days are in between (-) to 90 Days, then Rebate will be 1% of Gross value.
If Type is blank & Days are in between 91 to 180 Days, then Rebate will be 0.5% of Gross value.
If Type is blank, & Days are more than 180 then Rebate will be 0.
I have highlighted desired results, but only a single formula will cover up all these conditions. Pls help.
Regards
RAMU
Working in a workbook where there are multiple if conditions:
Sheet1
A | B | C | D | E | F | G | H | I | J | |
1 | PARTY NAME | DATE | TYPE | DOC | ADDRESS | GROSS VALUE | ADV | AMOUNT | Days | Rebate |
2 | MAA LAXMI TRADER | 14-08-16 | D | A-122 | 20500 | 2200 | 22700 | 0 | 102.5 | |
3 | BISWAS STORES | 13-09-16 | B-20 | 44000 | 3300 | 47300 | -3 | 440 | ||
4 | MAA LAXMI TRADER | 12-09-16 | D | A-215 | 3500 | 466 | 3966 | 91 | 8.75 | |
5 | BISWAS STORES | 12-12-16 | B-165 | 6000 | 877 | 6877 | 181 | 0 | ||
6 | RAJA ENTERPRISE | 26-07-16 | D | A-05 | 11300 | 1254 | 12554 | 178 | 28.25 | |
7 | BISWAS STORES | 22-12-16 | B-183 | 2400 | 120 | 2520 | 76 | 24 |
<colgroup><col style="WIDTH: 30px; FONT-WEIGHT: bold"><col style="WIDTH: 176px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 108px"><col style="WIDTH: 95px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody>
</tbody>
If Type is D, & Days are in between (-) to 90 Days, then Rebate will be 0.5% of Gross value.
If Type is D, & Days are in between 91 to 180 Days, then Rebate will be 0.25% of Gross value.
If Type is D, & Days are more than 180 then Rebate will be 0.
If Type is blank & Days are in between (-) to 90 Days, then Rebate will be 1% of Gross value.
If Type is blank & Days are in between 91 to 180 Days, then Rebate will be 0.5% of Gross value.
If Type is blank, & Days are more than 180 then Rebate will be 0.
I have highlighted desired results, but only a single formula will cover up all these conditions. Pls help.
Regards
RAMU