Excelmasters
Board Regular
- Joined
- Jun 11, 2015
- Messages
- 115
Hello All,
I need a Nested if and am sure i will get some help here.
My answer should be in cell b20
My criteria is
Note difference amount is in B19
Excel 2010
<tbody>
</tbody>
Excel 2010
<tbody>
</tbody>
I need a Nested if and am sure i will get some help here.
My answer should be in cell b20
My criteria is
Note difference amount is in B19
Excel 2010
D | E | F | G | H | |
---|---|---|---|---|---|
5 | if Invoice amount is less than | 500 | |||
6 | different amount can be | 10 or lesser | |||
7 | |||||
8 | |||||
9 | if Invoice amount is between | <500 to 1000> | |||
10 | different amount can be | 50 or lesser | |||
11 | |||||
12 | if Invoice amount is more than | 1000 | |||
13 | different amount can be | 100 or lesser | |||
14 | |||||
15 | if any condition matches it should be "ok to process" or else "Need to work" |
<tbody>
</tbody>
Sheet1
Excel 2010
B | C | |
---|---|---|
2 | Invoices Less than 500 | |
3 | Invoice Amount$ | $ 500.00 |
4 | Receipt$ | $ 10,000.00 |
5 | $ 5,000.00 | |
6 | $ 3,000.00 | |
7 | ||
8 | ||
9 | ||
10 | ||
11 | ||
12 | ||
13 | ||
14 | ||
15 | CRI Letter$ | $ 1,250.00 |
16 | ||
17 | Receipt Total$ | $ 18,000.00 |
18 | Receipt plus Letter$ | $ 19,250.00 |
19 | Diff amt$ | $ 10.00 |
20 | ok to process | |
21 | ||
22 |
<tbody>
</tbody>
Data