Forum Discussion
chose the wrire answer
Hi everyone,
let me know about the correct formula and also explain it
given the table blow, which of the following formula should be entered in cell D2 to calculate the total cost of the group subscription based on monthly cost table?(select all the apply)
A | B | C | D | E | F | G | H |
Serial no | Subscription type | No of subscription | Total cost p.month |
|
| Subscription type | COST P.MONTH |
1 | Monthly | 100 |
|
|
| monthly | 10 |
2 | Yearly | 130 |
|
|
| yearly | 9 |
3 | monthly | 110 |
|
|
| qualterly | 6 |
4 | yealy | 50 |
|
|
|
|
|
5 | quartly | 20 |
|
|
|
|
|
|
|
|
|
|
|
|
|
- Vlookup(B2,$G$1:$H$4,2)*C2
- INDEX($H$2:$H$4,MACTH(B2,$G$2:$G$4,0))
- C2*INDEX($H$2:$H$4,MACTH(B2,$G$2:$G$4,0)
- VLOOKUP(B2,$G$1:$H$4,2)
1 Reply
If you correct typos in some formulas and add multiplication on number of subscriptions where missed, you may use any of them
