IITM

Add New Topic

Chapter Details

Select Subject

Display Order

Topic Title

Content Details

<blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">As we know very well in MS-Excel
user can enter four types of data i.e. text, numeric, formula and logical
formula.                        Logical
formula means that formula where user can define the condition and computer
returns result after match the condition.            There are following formulas: -<o:p></o:p>If(): -It is a type
of logical formulas which determine the condition is true / false one value
display the condition is true and one value return the condition is false. <o:p></o:p>                                    Syntax:
-=If(condition,â€passâ€,â€failâ€)<table class="MsoTableGrid" border="1" cellspacing="0" cellpadding="0" style="border: none;">
 <tbody><tr>
 <td width="42" valign="top" style="width: 31.3pt; border-width: 1pt; border-style: solid; border-color: black; padding: 0in 5.4pt;">
 <o:p> </o:p>
 </td>
 <td width="59" valign="top" style="width: 43.95pt; border-top: 1pt solid black; border-right: 1pt solid black; border-bottom: 1pt solid black; padding: 0in 5.4pt;">
 A<o:p></o:p>
 </td>
 <td width="75" valign="top" style="width: 55.95pt; border-top: 1pt solid black; border-right: 1pt solid black; border-bottom: 1pt solid black; padding: 0in 5.4pt;">
 B<o:p></o:p>
 </td>
 <td width="51" valign="top" style="width: 38.6pt; border-top: 1pt solid black; border-right: 1pt solid black; border-bottom: 1pt solid black; padding: 0in 5.4pt;">
 C<o:p></o:p>
 </td>
 <td width="51" valign="top" style="width: 38.6pt; border-top: 1pt solid black; border-right: 1pt solid black; border-bottom: 1pt solid black; padding: 0in 5.4pt;">
 D<o:p></o:p>
 </td>
 <td width="64" valign="top" style="width: 47.75pt; border-top: 1pt solid black; border-right: 1pt solid black; border-bottom: 1pt solid black; padding: 0in 5.4pt;">
 E<o:p></o:p>
 </td>
 <td width="67" valign="top" style="width: 50.6pt; border-top: 1pt solid black; border-right: 1pt solid black; border-bottom: 1pt solid black; padding: 0in 5.4pt;">
 F<o:p></o:p>
 </td>
 <td width="51" valign="top" style="width: 38pt; border-top: 1pt solid black; border-right: 1pt solid black; border-bottom: 1pt solid black; padding: 0in 5.4pt;">
 G<o:p></o:p>
 </td>
 <td width="90" valign="top" style="width: 67.15pt; border-top: 1pt solid black; border-right: 1pt solid black; border-bottom: 1pt solid black; padding: 0in 5.4pt;">
 H<o:p></o:p>
 </td>
 <td width="55" valign="top" style="width: 41.4pt; border-top: 1pt solid black; border-right: 1pt solid black; border-bottom: 1pt solid black; padding: 0in 5.4pt;">
 I<o:p></o:p>
 </td>
 <td width="54" valign="top" style="width: 40.75pt; border-top: 1pt solid black; border-right: 1pt solid black; border-bottom: 1pt solid black; padding: 0in 5.4pt;">
 J<o:p></o:p>
 </td>
 </tr>
 <tr>
 <td width="42" valign="top" style="width: 31.3pt; border-right: 1pt solid black; border-bottom: 1pt solid black; border-left: 1pt solid black; padding: 0in 5.4pt;">
 1<o:p></o:p>
 </td>
 <td width="59" valign="top" style="width: 43.95pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 ROLL<o:p></o:p>
 </td>
 <td width="75" valign="top" style="width: 55.95pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 NAME<o:p></o:p>
 </td>
 <td width="51" valign="top" style="width: 38.6pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 PHY<o:p></o:p>
 </td>
 <td width="51" valign="top" style="width: 38.6pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 CHE<o:p></o:p>
 </td>
 <td width="64" valign="top" style="width: 47.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 MATH<o:p></o:p>
 </td>
 <td width="67" valign="top" style="width: 50.6pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 TOTAL<o:p></o:p>
 </td>
 <td width="51" valign="top" style="width: 38pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 PER<o:p></o:p>
 </td>
 <td width="90" valign="top" style="width: 67.15pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 PASS/FAIL<o:p></o:p>
 </td>
 <td width="55" valign="top" style="width: 41.4pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 DIV1<o:p></o:p>
 </td>
 <td width="54" valign="top" style="width: 40.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 DIV2<o:p></o:p>
 </td>
 </tr>
 <tr>
 <td width="42" valign="top" style="width: 31.3pt; border-right: 1pt solid black; border-bottom: 1pt solid black; border-left: 1pt solid black; padding: 0in 5.4pt;">
 2<o:p></o:p>
 </td>
 <td width="59" valign="top" style="width: 43.95pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 1<o:p></o:p>
 </td>
 <td width="75" valign="top" style="width: 55.95pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 RAJ<o:p></o:p>
 </td>
 <td width="51" valign="top" style="width: 38.6pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 90<o:p></o:p>
 </td>
 <td width="51" valign="top" style="width: 38.6pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 78<o:p></o:p>
 </td>
 <td width="64" valign="top" style="width: 47.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 65<o:p></o:p>
 </td>
 <td width="67" valign="top" style="width: 50.6pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 <o:p> </o:p>
 </td>
 <td width="51" valign="top" style="width: 38pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 <o:p> </o:p>
 </td>
 <td width="90" valign="top" style="width: 67.15pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 <o:p> </o:p>
 </td>
 <td width="55" valign="top" style="width: 41.4pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 <o:p> </o:p>
 </td>
 <td width="54" valign="top" style="width: 40.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 <o:p> </o:p>
 </td>
 </tr>
 <tr>
 <td width="42" valign="top" style="width: 31.3pt; border-right: 1pt solid black; border-bottom: 1pt solid black; border-left: 1pt solid black; padding: 0in 5.4pt;">
 3<o:p></o:p>
 </td>
 <td width="59" valign="top" style="width: 43.95pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 2<o:p></o:p>
 </td>
 <td width="75" valign="top" style="width: 55.95pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 RAJU<o:p></o:p>
 </td>
 <td width="51" valign="top" style="width: 38.6pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 78<o:p></o:p>
 </td>
 <td width="51" valign="top" style="width: 38.6pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 90<o:p></o:p>
 </td>
 <td width="64" valign="top" style="width: 47.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 87<o:p></o:p>
 </td>
 <td width="67" valign="top" style="width: 50.6pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 <o:p> </o:p>
 </td>
 <td width="51" valign="top" style="width: 38pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 <o:p> </o:p>
 </td>
 <td width="90" valign="top" style="width: 67.15pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 <o:p> </o:p>
 </td>
 <td width="55" valign="top" style="width: 41.4pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 <o:p> </o:p>
 </td>
 <td width="54" valign="top" style="width: 40.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 <o:p> </o:p>
 </td>
 </tr>
 <tr>
 <td width="42" valign="top" style="width: 31.3pt; border-right: 1pt solid black; border-bottom: 1pt solid black; border-left: 1pt solid black; padding: 0in 5.4pt;">
 4<o:p></o:p>
 </td>
 <td width="59" valign="top" style="width: 43.95pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 3<o:p></o:p>
 </td>
 <td width="75" valign="top" style="width: 55.95pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 MOHAN<o:p></o:p>
 </td>
 <td width="51" valign="top" style="width: 38.6pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 56<o:p></o:p>
 </td>
 <td width="51" valign="top" style="width: 38.6pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 78<o:p></o:p>
 </td>
 <td width="64" valign="top" style="width: 47.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 89<o:p></o:p>
 </td>
 <td width="67" valign="top" style="width: 50.6pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 <o:p> </o:p>
 </td>
 <td width="51" valign="top" style="width: 38pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 <o:p> </o:p>
 </td>
 <td width="90" valign="top" style="width: 67.15pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 <o:p> </o:p>
 </td>
 <td width="55" valign="top" style="width: 41.4pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 <o:p> </o:p>
 </td>
 <td width="54" valign="top" style="width: 40.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 <o:p> </o:p>
 </td>
 </tr>
</tbody></table>Q.1.    Calculate for pass total should be greater than
200                        =If(F2>=200,â€Passâ€,â€failâ€)Q.2.    Calculating division                        >=60%         -           First                        >=45%         -           Second                        >=30%         -           Third                        Otherwise   -           Fail            =If(G2>=60,â€Firstâ€,If(G2>=45,â€Secondâ€,If
(G2>=30,â€Thirdâ€,â€Failâ€)))Q.3.
   Subject Wise=If(And(C2>=30,D2>=30,E2>=30,G2>=60),â€Firstâ€,If(And(C2>=30,D2>=30,E2>=30,G2>=45),â€Secondâ€,If(And(C2>=30,D2>=30,E2>=30,G2>=30),â€Thirdâ€,â€
Failâ€)))<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="right" width="256" style="width: 192pt; margin-left: 6.75pt; margin-right: 6.75pt;">
 <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;height:15.0pt">
 <td width="64" nowrap="" style="width: 48pt; border-width: 1pt; border-style: solid; border-color: windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">A<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-top: 1pt solid windowtext; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">B<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-top: 1pt solid windowtext; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">C<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-top: 1pt solid windowtext; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">D<o:p></o:p>
 </td>
 </tr>
 <tr style="mso-yfti-irow:1;height:15.0pt">
 <td width="64" nowrap="" style="width: 48pt; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; border-left: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">1<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">COURSE<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">NAME<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">FEE<o:p></o:p>
 </td>
 </tr>
 <tr style="mso-yfti-irow:2;height:15.0pt">
 <td width="64" nowrap="" style="width: 48pt; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; border-left: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">2<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">DCA<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">MOHAN<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">3250<o:p></o:p>
 </td>
 </tr>
 <tr style="mso-yfti-irow:3;height:15.0pt">
 <td width="64" nowrap="" style="width: 48pt; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; border-left: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">3<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">ADCA<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">SOHAN<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">8000<o:p></o:p>
 </td>
 </tr>
 <tr style="mso-yfti-irow:4;height:15.0pt">
 <td width="64" nowrap="" style="width: 48pt; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; border-left: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">4<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">DOA<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">RAJ<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">5000<o:p></o:p>
 </td>
 </tr>
 <tr style="mso-yfti-irow:5;height:15.0pt">
 <td width="64" nowrap="" style="width: 48pt; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; border-left: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">5<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">DOA<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">RAHUL<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">4900<o:p></o:p>
 </td>
 </tr>
 <tr style="mso-yfti-irow:6;height:15.0pt">
 <td width="64" nowrap="" style="width: 48pt; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; border-left: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">6<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">ADCA<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">AMAN<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">7500<o:p></o:p>
 </td>
 </tr>
 <tr style="mso-yfti-irow:7;height:15.0pt">
 <td width="64" nowrap="" style="width: 48pt; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; border-left: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">7<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">DOA<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">IRSHAD<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">4800<o:p></o:p>
 </td>
 </tr>
 <tr style="mso-yfti-irow:8;height:15.0pt">
 <td width="64" nowrap="" style="width: 48pt; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; border-left: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">8<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">DCA<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">ANAND<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">2750<o:p></o:p>
 </td>
 </tr>
 <tr style="mso-yfti-irow:9;height:15.0pt">
 <td width="64" nowrap="" style="width: 48pt; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; border-left: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">9<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">DCA<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">RAJA<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">2500<o:p></o:p>
 </td>
 </tr>
 <tr style="mso-yfti-irow:10;mso-yfti-lastrow:yes;height:15.0pt">
 <td width="64" nowrap="" style="width: 48pt; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; border-left: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">10<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">ADCA<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">RAJEEV<o:p></o:p>
 </td>
 <td width="64" nowrap="" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
 justify;line-height:normal;mso-element:frame;mso-element-frame-hspace:9.0pt;
 mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:right;mso-element-top:18.55pt;mso-height-rule:exactly">7000<o:p></o:p>
 </td>
 </tr>
</tbody></table> Sumif(): -This
Logical Function is used to sum numerical cells range value according to specified
condition by the user.<o:p></o:p>Syntax: -
=Sumif(Range to check,â€Criteriaâ€, Range to total)<o:p></o:p>Ex: -               =Sumif(B1:B11,"DCA", D1:D11)<o:p> </o:p>Countif(): -This
function is used to count the number of cells which satisfies the condition.                                    Syntax: -       =Countif(Range to check,â€Criteriaâ€)<span style="font-size:14.0pt;line-height:115%;font-family:"Cambria","serif";
mso-ascii-theme-font:major-latin;mso-fareast-font-family:Calibri;mso-fareast-theme-font:
minor-latin;mso-hansi-theme-font:major-latin;mso-bidi-font-family:Mangal;
mso-bidi-theme-font:minor-bidi;mso-ansi-language:EN-US;mso-fareast-language:
EN-US;mso-bidi-language:AR-SA">                                    Ex: -               =Countif(B1:B11,â€Dcaâ€)</blockquote>

Your order is placed

James Lemire

Your item is shipped

Salena Layfield

Add New Topic

Short Key List