.1 I'm trying to find a formula that matches the suitability of each worker for the group to which the worker is assigned.
Suitability rating
Group 1 Group 2 Group 3 Group 4
Assigned to Worker 1 2 3 4
4 1 9 8 6 8
1 2 10 0 5 6
3 3 5 8 10 5
Considered using vlookup, hlookup - but just not sure how they work exactly
2. Number of ads Price per ad
1-5 12k
6-10 11k
11-20 10k
21 and higher 9k
I'm trying to find a formula that yields the total cost of purchasing any number of ads. For example, if you buy 8 ads, you pay $11,000 per ad, but if you buy 14 ads, you pay$10,000 per ad.
Suitability rating
Group 1 Group 2 Group 3 Group 4
Assigned to Worker 1 2 3 4
4 1 9 8 6 8
1 2 10 0 5 6
3 3 5 8 10 5
Considered using vlookup, hlookup - but just not sure how they work exactly
2. Number of ads Price per ad
1-5 12k
6-10 11k
11-20 10k
21 and higher 9k
I'm trying to find a formula that yields the total cost of purchasing any number of ads. For example, if you buy 8 ads, you pay $11,000 per ad, but if you buy 14 ads, you pay$10,000 per ad.
Last edited: