Question one: cell K$2-$ Enter a formula that results in either the savings or additional cost of selling a piece of equipment and purchasing a new piece to replace it

Question two: cell L$2-$ Enter in IF function to return the value in cell K$2,$ but only if the amount is positive. Entries in this column indicate this equipment should be replaced

Question three: cell M$2-$ Enter in IIF function to return the value in cell K$2,$ but only if that amount is negative. Entries in this column indicate this equipment should be kept.

The next questions are in relation to a pivot table, please tell me how to set up the pivot table to get the correct answers. The filters are residual and new, current annual direct labor, new annual direct labor, savings or extra cost with replacement, replace, keep

Question one: What amount of money will the company save if the scanners that should be replaced at the Clifton Springs facility or actually replaced with new ones?

Question two: How many disseminators at the Baker enclave facility should be kept rather than be replaced with new ones?

Question three: What amount of money will the company forgo if it replaces all of the equipment at the Focks corners facility?

Question four: What is the total cost of all the new coolers at the Palma Valley facility if those that should be replaced are actually replaced?