Question

The Power of Logical Functions"

• Logical functions, such as the IF and IFS functions, provide accountants with a lot of power to ensure that accurate and correct data is processed in Excel. Identify and discuss at least three (3) types of accounting worksheets that will benefit from using logical functions like the IF function. Explain why these worksheets would benefit from the use of logical functions. Justify your response.

Answer 1

Answer The IF Function can be used to evaluab text, values and even errors It is not limited to only checking if one thing is equel to another and returning single result If formular = If Clogical test, value if true, value if- false) trample I Suppose we wish to do very simple test we Want to test if the valde in the cell a is greater than orequal to the valulin Cell Dz. If the argument is true, then we want to return some tent stating Tes it is", and if it is not true then we want to display No It is not" You can breitin Encel] ABCDE The answer will appear almentimed in figure 7 Frample TIT tellers frequently provide a discount hared on the quantity purchased foreg 1 Unit quantal Pricfer using iffunction, we Titolo / $30 kan create a formule! B litors $28 tocheck multiple 14 26 tabs $25 onditions and resten 15 bande $22 different Glulatie depending onwhat ant range the specifice quanteth, falls in Tolalculate the total price for 175 items, the formulas will T ज्यका off Cel 7 buelt 2 test is to it isn't) o sity- unit of Plice Perunt. toloy $30 15116 $28 25 to 65 $25 blonde $22 I quantit 75 Total = 26*TA (6=6522 Ifec67=26, 25, IF (C6 = 11,28, IF (667=1,30*")))) I answer = 1650. kreample 2-We wish totust a cell and ensure that an actions taken if the cell is not blank we are given the data belows 3 9 AM There are many reasons forwhich there worksheet are beneficial to accountant Common enamples or reason include a). To test if an argument is true orgabe 3 To outpul a number 9 Tourate asteanariostbeusedia financial modeling d) Tocalculate adebt schedule or a fined asset depriciate Schodule in accounterych AGM Preparatem hist statues Remarks pirator report to be closed 01/01/2010 finalize Annual report open AGM notice closed 11/15/18 In the worksheet welisted AGM task, status andremarks. In columm , we will use formule to check of the cells in the Colic an empty anot. If the cellis blank the forroule will assign the status open If the cell contains a date, then formule will assign the status. 1 2 AGM Preparatem list status Remarks Ductor report to be finely SIFD24''dese oben Finelize Annad report ASM Notice