Question: using the excel functions v-lookup and iferror should look somewhat like this but im stuck Exercise 1: Contributions are classified as follows: Under 100: O
using the excel functions v-lookup and iferror
should look somewhat like this but im stuck
Exercise 1: Contributions are classified as follows: Under 100: O supporter $100yo $399: 100 Patron $400/t$999: 400 Fellow $1960 or more: 1000 Elite Create a worksheet which allows you to enter a contribution amount (input) and then will automatically display the contributor's classification (output). Use a lookup table (you create table). Also, if the user enters an invalid contribution amount, the worksheet should display t error message 'Please enter a valid contribution amount". 4 Contributions amount Classification 5 Amount Classification 7 10 lookup table 12 O Supporter 100 Patron 400 Fellow 1000 Elite 13 14 15 16 17 18 19 20
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
