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) |