Excel can provide data analysis when you need to evaluate multiple conditions within one formula. One such example includes using nested statements to calculate realtor commission splits on the sale of a property (Project 6-4). How would you explain to someone who is unfamiliar with Excel how to read a nested statement that contains 3 different conditions?
The response should include a reference list. Double-space, using Times New Roman 12 pnt font, one-inch margins, and APA style of writing and citations.