Help Save&Exit Subrri Variance Analysis using Excel's ABS, IF and Basic Math Functions Patterson, Inc tas pravided detal's of ts actual cast data for the month. The Controlles tias asked you to compute the Dask vartlances and the impact of those varlances on unrt costs Use the information ncuded in the Excel Snation and the Expes functon descmbed below to compiete Cell Reference' Alows you TO refer to dara rom another cel, in the nosneet Fron, he ien ma ,en ese.. san, ni- entered, the formula would output thhe result from cet D4, or 2 75 in this examplie Basic Meth functions: A lows you to use the basK math symbols 10 perform mdthematcar turctons vou can use the followng keys . plus sign to aod (minus sign to subtract. (asterisk sign to mutipy), and iorward slach to avide) From the Excei Smulistion below, it n a biank cel "f44G5" wa, entered, the formula would add the values torm those cet and output the resit, or ? 70 in ms example r uring the other math symbols the resut wold output an appropnate answer for its function SUM function: Allows you to refer to muttiple cels and adds all the values You can add indoual ceflreferences or ranges to utraze the function From the Excel Simulation belkcrw, if in a blank cell -SUMID4 DS) was emered, the tormda woud output the tesut of ading those two separate cells, or 5.45 in thrs exampie. Simmary. If in a biank cell -SUMID4DS was entered the formula wourd output the same resut of adding those celis. except they are expressed as a range in the formula, and the re ABS function: ARows you to return the or surround anotner formula with the ABS function, to return the nnal result as an absolute value. From the blarik cell you entered ABS/F 7 GB Excet il trst caiculiate the subitraction of FI G8 that results in o 20 forrnula returns the absolute value of the sutraction resur, wtch would be?20 in tris example IF function: Alows you to test a condion and retun a the IF function is itest condtion value M trve,vale faset and The test condition araument is an evoaluation of the status of a cell such as it tne value of a cel s arealer than, less than or ecual to another sut woukt De 5 45 in tis exampie atrsolute vatue of a number or calcuiston You can reference aty cet to display ts absolute vaue Excel SImulation below. if ina specinic value ts the result is true and amerent value i the result is false The syntax of specite conderatios, neeo to be made when usang thes function 1 of 3 Next> ?? search