Sheet1
<colgroup><col style="width: 30px;"><col style="width: 78px;"><col style="width: 105px;"><col style="width: 64px;"><col style="width: 121px;"><col style="width: 64px;"><col style="width: 117px;"><col style="width: 64px;"><col style="width: 93px;"></colgroup><tbody>
</tbody>
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
I have a formula in D2 which compares my data in D5:D13 with B5:B13 individually. If there is an increase beyond tolerance in the values, the return value in D2 is "IBL" which means (Increased beyond Limit). I have put the same formula in F2 and H2. As per the formula the column H is compared with F and F is compared with D and D is compared with B.
If there is no increase beyond tolerance it returns me IWL which means (Increased within tolerance)
Till here everything is fine. The difficult part comes here. The formula is calculating everything perfectly.
But now I want a change that I am not able to do. The change is as follows:
The column H is compared with F, but if F2 is IWL then instead of comparing with column F the comparison should be made with column D. if D2 also has IWL then the comparison should be made with Column B. The shifting of the formula is what i find challenging. Please advise.
A | B | C | D | E | F | G | H | |
1 | 1st Loan Estimate | 2nd Loan Estimate | 3rd Loan Estimate | Actual Charge | ||||
2 | IBL | IBL | IBL | |||||
3 | ||||||||
4 | Section A | |||||||
5 | 496 | 458 | 417 | 493 | ||||
6 | 411 | 418 | 482 | 489 | ||||
7 | 449 | 466 | 434 | 463 | ||||
8 | 425 | 447 | 419 | 498 | ||||
9 | Section B | |||||||
10 | 226 | 200 | 202 | 206 | ||||
11 | 217 | 210 | 200 | 217 | ||||
12 | 228 | 248 | 223 | 233 | ||||
13 | 240 | 242 | 232 | 230 | ||||
14 | Section C | |||||||
15 | 353 | 319 | 315 | 348 | ||||
16 | 396 | 381 | 367 | 392 | ||||
17 | 354 | 332 | 386 | 307 | ||||
18 | 347 | 358 | 321 | 333 |
<colgroup><col style="width: 30px;"><col style="width: 78px;"><col style="width: 105px;"><col style="width: 64px;"><col style="width: 121px;"><col style="width: 64px;"><col style="width: 117px;"><col style="width: 64px;"><col style="width: 93px;"></colgroup><tbody>
</tbody>
Spreadsheet Formulas | ||||||||
<tbody> </tbody> | ||||||||
Formula Array: Produce enclosing { } by entering formula with CTRL+SHIFT+ENTER! |
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
I have a formula in D2 which compares my data in D5:D13 with B5:B13 individually. If there is an increase beyond tolerance in the values, the return value in D2 is "IBL" which means (Increased beyond Limit). I have put the same formula in F2 and H2. As per the formula the column H is compared with F and F is compared with D and D is compared with B.
If there is no increase beyond tolerance it returns me IWL which means (Increased within tolerance)
Till here everything is fine. The difficult part comes here. The formula is calculating everything perfectly.
But now I want a change that I am not able to do. The change is as follows:
The column H is compared with F, but if F2 is IWL then instead of comparing with column F the comparison should be made with column D. if D2 also has IWL then the comparison should be made with Column B. The shifting of the formula is what i find challenging. Please advise.