Muthukrishnan V
Active Member
- Joined
- May 29, 2008
- Messages
- 280
- Office Version
- 365
- Platform
- Windows
| Book1 | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 2 | Excel 365 | ||||||||
| 3 | Column F contains formula to get the minimum amount. | ||||||||
| 4 | Request formula for Column G to get the applicable scheme. | ||||||||
| 5 | Name | Category | Scheme 1 | Scheme 2 | Scheme 3 | Minimum | Scheme | ||
| 6 | ABC | P | 1,43,750 | 1,47,580 | 1,45,550 | 1,43,750 | Scheme 1 | ||
| 7 | DEF | S | 75,990 | 83,040 | 73,130 | 73,130 | Scheme 3 | ||
| 8 | GHI | V | 71,240 | 68,360 | 69,400 | 68,360 | Scheme 2 | ||
| 9 | JKL | D | 47,34,620 | 49,43,500 | 48,24,800 | 47,34,620 | Scheme 1 | ||
| 10 | |||||||||
| 11 | |||||||||
Sheet1 | |||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| F6:F9 | F6 | =MIN(C6:E6) |
