80.2K

Verified Solution

Link Copied!

What If function should I put in J2 Please In the CustomerData worksheet, in the J2:J21 range, enter an IF function to identify whether the client should be saved or released. The end result will say SAVE if the client has a high balance of over 50,000 and the type of client is Corp or Serv. Otherwise, the end result will say "Release". E 12442 OriginalClientName GEORGE BRANT cr burris/accnt Jean/Rose Garden Bonnie Gerber Marissa Taylor, Angela Harper, Lynette Grabowski KIRSTEN LESTON Eileen Max 88835 Maggie Miller D 1 City State Zip 2 Baltimore MD 21203 3 Carlisle PA 17013 4 Hunter NY 5 Manassas VA 22110 6 Ogunquit ME 7 New Haven 06511 8 New Orleans LA 70001 9 Hoboken NJ 07030 10 Berkeley CA 194706 11 Malvern PA 19355 12 San Francisco CA '94965 13 Santa Clara CA 14 San Fernando CA 91344 15 San Antonio TX 78230 16 Helena MT 59601 17 San Jose CA 95148 18 Silver Spring MD 20904 19 Fairborn OH 45324 20 Austin TX 78759 21 Manchester '06040 22 23 F G H ReviewDate HighBalance TypeOfClient 17-Jun-03 35,000.00 Corp 15-Apr-03 67,555.00 Serv 22-Oct-01 434.00 Nonp 15-Dec-96 23,444.00 Nonp 17-Jun-02 1,254.00 Nonp 19-Mar-99 0.00 Nonp 15-Jul-01 676,567.00 Serv 15-Apr-02 5,674.00 Serv 20-Feb-00 345,345.00 Nonp 15-Jul-01 234,234.00 Serv 17-Jun-96 7,656,870.00 Serv 15-Dec-02 47,670.00 Corp 15-Dec-02 456.00 Corp 19-Mar-99 98,789.00 Serv 19-Apr-00 678.00 Corp 12-Aug-99 567,568.00 Corp 20-Feb-00 4,564,587.00 Corp 15-Apr-02 67,867.00 Corp 12-Aug-99 456,456.00 Corp 15-Dec-96 57,567.00 Corp Save Or Release Release Save Release Release Release Release Save Release Release Save Save Release Release Save Release Release Release Release Release Release will patience marge/remax John Ross/Witi MARY SCHOEMAKER James Shener cio forum/sim John Smith JEREMY SNOW Joe Schmoe/Marissa Taylor Joe Schmoe/Sovereign Security morgan tate/sovereign security Kevin Tookus/Heritage Antique 95050

Answer & Explanation Solved by verified expert

See Answer