Excel Tutorials

Example:- Rajeev Ranjan Kumar:-  O/p first name;- = IFERROR(LEFT(A21,(FIND(” “,A21))-1),A21)    mid name;- = MID(A21,FIND(” “,A21)+1,FIND(” “,A21,1+FIND(” “,A21))-FIND(” “,A21)-1) last name:- = RIGHT(A21,LEN(A21)-FIND(” “,A21,FIND(” “,A21)+1)) here “A21″ is a cell value ref.

SNO Project Title 1 Remote Controlled Robot Using the Android Applications 2 Railway Level Crossing Gate Operation Using Remote 3 Password Based Remote Controlled Door Opening System Using Android Applications 4 Metal Detection Robotic Vehicle 5 Remote Induction Motor Control with 7 Segment Display 6 Pick N Place Robotic Arm Controlled by Wireless Android Applications 7 Remote Password Operated Security Control by Android Applications 8 Remotely Operated Fire Fighting Robot by Android Applications 9 Remote Speed Control of DC Motor by Android Applications 10 Remote Controlled Home Automation Using Android Applications 11 Remotely Controlled Android Based Electronic Notice Board 12 Remote Operated Domestic Appliances Control by Using Android Application 13 Remote Operated AC Power Control with LCD Display Using Android Applications 14 War Field Spying Robot with Night Vision Wireless Camera By Android Applications 15 Remotely Operated

What Does It Do ? This function examines a list of information and produces the total. Syntax =DSUM(DatabaseRange,FieldName,CriteriaRange) The DatabaseRange is the entire list of information you need to examine, including the field names at the top of the columns. The FieldName is the name, or cell, of the values to be totalled, such as "Value Of Stock" or I3. The CriteriaRange is made up of two types of information.    The first set of information is the name, or names, of the Fields(s) to be used as the basis    for selecting the records, such as the category Brand or Wattage.    The second set of information is the actual record, or records, which are to be selected, such     as Horizon as a brand name, or 10