Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What nested IF function should I put in K2 please? In the CustomerData worksheet, in the K2:K21 range, enter an IF function to estimate the
What nested IF function should I put in K2 please?
In the CustomerData worksheet, in the K2:K21 range, enter an IF function to estimate the projected balance next year. If the client is in CA, the projected balance will be 2% higher than last year. If the client is not in CA, and the client type is Nonp, then the projected balance will be 3% higher than last year. If the client type is not CA and not Nonp, then the projected balance will be 4% higher than last year. Hint: You do not need to calculate the project balance, just put the percent (2% or 3% or 4%). However, make sure that your result is a number so that if someone were to calculate the actual projected balance, they could do so. Also - don't forget that if you've already tested for being in California, you don't need to test again, so that condition should only appear once. u D E F Percent Next Year Save Or Release Release Save Release Release 94706 1 City State Zip 2 Baltimore MD 21203 3 Carlisle PA 17013 4 Hunter NY 12442 5 Manassas VA 22110 6 Ogunquit ME 88835 7 New Haven 06511 8 New Orleans LA 70001 9 Hoboken NJ 07030 10 Berkeley CA 11 Malvern PA 19355 12 San Francisco CA 94965 13 Santa Clara CA 95050 14 San Fernando CA 91344 15 San Antonio TX 78230 16 Helena 59601 17 San Jose CA 95148 18 Silver Spring 19 Fairborn OH 45324 20 Austin TX 78759 21 Manchester 06040 22 23 G H ReviewDate HighBalance Typeofclient Original clientName 17-Jun-03 35,000.00 Corp GEORGE BRANT 15-Apr-03 67,555.00 Serv cr burris/accnt 22-Oct-01 434.00 Nonp Jean/Rose Garden 15-Dec-96 23,444.00 Nonp Bonnie Gerber 17-Jun-02 1,254.00 Nonp Marissa Taylor, Angela Harper, Lynette Grabowski 19-Mar-99 0.00 Nonp KIRSTEN LESTON 15-Jul-01 676,567.00 Serv Eileen Max 15-Apr-02 5,674.00 Serv Maggie Miller 20-Feb-00 345,345.00 Nonp will patience 15-Jul-01 234,234.00 Serv marge/remax 17-Jun-96 7,656,870.00 Serv John Ross/Witi 15-Dec-02 47,670.00 Corp MARY SCHOEMAKER 15-Dec-02 456.00 Corp James Shener 19-Mar-99 98,789.00 Serv cio forum/sim 19-Apr-00 678.00 Corp John Smith 12-Aug-99 567,568.00 Corp JEREMY SNOW 20-Feb-00 4,564,587.00 Corp Joe Schmoe/Marissa Taylor 15-Apr-02 67,867.00 Corp Joe Schmoe/Sovereign Security 12-Aug-99 456,456.00 Corp morgan tate/sovereign security 15-Dec-96 57,567.00 Corp Kevin Tookus/Heritage Antique Release Release Save Release Release Save Save Release Release Save Release Release Release Release Release Release MD 20904Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started