column :- A B C D E F G H I J K L .... ... .... ... ... .....
Row :- 1 2 3 4 5 6 7 8 9 10 11 12 .... .... .... .... ... ....
Excel में कोई भी फार्मूला ( Formula ) लिखने से पहले बराबर (Equal sing = ) का निशान जरूर से लिखना है |
👉 = Sum (Initial Cell Address : Last Cell Address ) this Formula is used to sum the numeric Value.
E.g =sum(f3 : f10) Press Enter Key form the Key board.
we can also select the range of row or column and click on Auto Sum ∑ it calculate automatic the total value of the your selected data . Remember auto sum or sum formula only for numeric value.
👉 = f3- f4 For Subtract (- Minus Sing)
👉 = f3 * f4 For Multiply ( * Strict Sing)
👉 = f3 / f4 For Division ( / Slash sing)
👉 =Total Marks * percentage value with Sing e.g =500*10% for Percentage
👉 = Now() Press Enter It show the Date and Time in the Selected Cell
👉 = Today() Press Enter It show the only Date in the Selected Cell which is show in the computer
👉 = if ( a1>=300,"1st", if(a2>=225,"2nd",if(a2>=150,"3rd",if(a2<150,"Fail"))))
- This formula is used for calculate the division of Mark-sheet where as total marks is equal to 500
- This Format of formula is a Master format of Logical and conditional Problems.
- In this Formula we used the Logical Operator with multiple condition
👉 = Min (Int ital Cell address : Last Cell Address) to Find the Minimum value
e.g =Min (a1:a10) Press Enter
👉 = Max (Int ital Cell address : Last Cell Address) to Find the Maximum value
e.g =Max (a1:a10) Press Enter
👉 = Average (Int ital Cell address : Last Cell Address) to Find the Average value
e.g =average (a1:a10) Press Enter
👉 = Count(Int ital Cell address : Last Cell Address) to Find the umber of entries in a number field that is in a range or array of numbers.
e.g = count(a1:a10)
👉 = Count if(where do you want to look?, what do you want to look for ?) to count the number of times a particular city appears in a customer list.
e.g =countif(a1:a10,"Phulwari") it show the no of phulwari city in how many times repeated .
👉 = SUMIF Function to sum the values in a range that meet criteria that you specify.
e.g :- sumif (a1:a10,"Moday",c1:10) press enter
=sum if (range,"Criteria" range")
👉 =use of AND, OR function in Excel To See the Image 1
e.g :- ==IF(AND(C4>=50000,D4>=50000,E4>=5000),F4*2%,"Hardwork")
e.g :- =IF(OR(C4>=50000,D4>=50000,E4>=5000),F4*2%,"Hardwork")
