On the attendance worksheet, in cell l5, enter an if function to determine if the percentage in cell k5 is greater than or equal
to the goal in cell h18. the function should return the text goal met if true and review if false. set the reference to cell h18 as an absolute reference
we will use if function to check the validity of function
we will first write the condition and then we will write the value if condition goes true otherwise if condition does not go true we will write false and function will return value in k5 cell which we have provided in the formula.
You have tot do these steps: Ribbon 1.Click cell L5. On the FORMULAS tab, in the Function Library group, clickthe Logical, and then click IF. 2.In the Function Arguments dialog box, with the insertion point in the Logical_test box, type K5>=$H$18. 3.Press TAB to select the Value_if_true box. 4.Type Goal Met. 5.Press TAB to select the Value_if_false box. 6.Type Review. 7.Click OK.
Keyboard 1.Click cell L5, and type =IF(K5>=$H$18,"Goal Met","Review") (or =if(k5>=$h$18,"Goal Met","Review") or =IF($H$18=0.8,"Goal Met","Review") or =if(k5>=.80,"Goal Met","Review") or =IF(0.80 2.Press ENTER (or TAB or CTRL+ENTER or click the Enter button to the leftof the Formula Bar).
Keyboard (2) 1.Click in the Name box, type l5 (or L5), and then press ENTER. type =if( (or =IF( or =If(). 2.Click cell K5, and then type >=. 3.Click cell H18, press F4, and then type ,"Goal Met","Review". 4.Press ENTER (or TAB or CTRL+ENTER or click the Enter button to the left of the Formula Bar).
The best chart to see the data distribution for the exercise routine would be a pie chart. Using Microsoft Excel, you can input each data point you have for all you exercise routine category, and generate a pie chart which will show you the percentage for each category in comparison to the total.
