Marksheet in Excel Formula Tutorial by Sama Soyab

 

Open Microsoft Excel

-> Three Steps to Open MS Excel

1. Double Click on Ms Excel Icon

2. Start-> All Programs-> Microsoft Office -> Ms Excel

3. Start->Run-> Excel-> Ok

 => Fill the detail as above Image

Enter Detail Column A to I -> 

Total : =SUM(C4:I4)

SUM formula use for Calculate Sum of Total Subject Mark

- J4 -> Enter above Formula  =SUM(C4:I4)

 

Min : =MIN(C4:I4)

Min formula use for Calculate Minimum Value of Subject Mark

- K4 -> Enter above Formula  =MIN(C4:I4)

Max : =MAX(C4:I4)

Max formula use for Calculate Maximum Value of Subject Mark

- L4 -> Enter above Formula  =MAX(C4:I4)

 

Average : =if(N4="Fail","***",AVERAGE(C4:I4))

Average formula use for Calculate Average Value of Subject Mark

- M4 -> Enter above Formula  ==if(N4="Fail","***",AVERAGE(C4:I4))

 

Result : =If(K4>=35,"PASS","FAIL")

IF formula use is Conditional Formula We are check If Minimum Marks is Greater Then 35 then True Value - Means "Pass", and if not more then 35 then False Value - Means "Fail"

- N4 -> Enter above Formula  =If(K4>=35,"PASS","FAIL")

Search Topics : sama soyab, excel formulas, excel formulas with examples, excel formulas list, excel formulas pdf, excel formulas pdf free download, excel formulas pdf in hindi download, excel formulas and functions, excel formula for amount in words, excel formula list, excel formula pdf, excel formula for percentage, excel formula to convert number to words, excel formula for subtraction, excel formula with example, excel formula for addition, excel formula amount in words, excel formula and function, excel formula all, excel formula average, excel formula addition, excel formula and, excel formula and function pdf, excel formula age calculation, and excel formula if, ms excel formulas pdf, ms excel formulas list pdf, ms excel formula percentage, ms excel formulas functions, the excel formula for subtraction, excel and formula conditional formatting, excel and formula array, excel formula bar, excel formula begins with, excel formula between two numbers, excel formula bible, excel formula book, excel formula bar shortcut, excel formula bar not showing, excel formula bible pdf, a b excel formula, y=mx+b excel formula, if a=b excel formula, b&s formula excel, excel formula $b$2, if a then b excel formula, excel formula b-c=d, excel formula $b$1, excel formula concatenate, excel formula checker, excel formula countif, excel formula chart, excel formula count, excel formula cheat sheet, excel formula contains, excel formula calculator, erlang c excel formula, erlang c formula excel download, c to f excel formula, w/c formula excel, y=mx+c excel formula, r 1 c excel formula, excel formula $c$1, a b c formula excel, excel formula date, excel formula date to month, excel formula digit to word, excel formula date to month and year, excel formula download, excel formula date difference, excel formula divide, excel formula drag not working, excel d formula, cohen's d excel formula, 3-d formula excel, excel formula =$d$44, d'hondt formula excel, n/d formula excel, excel formula examples, excel formula error, excel formula explanation, excel formula error #value, excel formula editor, excel formula explanation tool, excel formula exercises, excel formula english to hindi, delta e excel formula, e^x excel formula, capital e excel formula, e constant excel formula, log base e excel formula, edate formula excel, formula e excel london, formula e excel track, excel formula for, excel formula for multiply, excel formula for multiplication, excel formula for minus, if excel formula, if excel formula with text, if excel formula not working, Keywords , if excel formula for multiple conditions, if excel formula for grades, if excel formula color cell, if excel formula is 0 leave blank, if excel formula range, excel formula greater than and less than, excel formula generator, excel formula grade, excel formula greater than, excel formula guide, excel formula greater than or equal to, excel formula generator online, excel formula giving wrong answer, p/g formula excel, excel formula g, excel formula hindi, excel formula hide, excel formula help, excel formula hyperlink, excel formula higher of two values, excel formula hlookup, excel formula hindi pdf, excel formula horizontal to vertical, excel h formula, h lookup excel formula, km/h formula excel, h-model formula excel, ctrl h in excel formula, excel formula if, excel formula if and condition, excel formula in hindi, excel formula if greater than, excel formula in pdf, excel formula if cell contains text, excel formula if else, excel formula in excel, excel i formula, excel formula join text, excel formula jobs, excel formula just showing as text, excel formula jump to cell, excel formula join, excel formula jokes, excel formula join strings, excel formula just shows formula, j curve formula excel, excel formula kaise sikhe, excel formula key, excel formula keyboard shortcuts, excel formula kya hai, excel formula keys pdf, excel formula keep cell constant, excel formula knowledge, excel formula keep same cell, excel k formula, excel k formula in hindi, k means excel formula, n choose k excel formula, excel formula k.esimo, excel formula list pdf, excel formula list with examples, excel formula list pdf download, excel formula list with examples pdf, excel formula lower of two values, excel formula list in hindi, excel formula left, all excel formulas, all excel formulas pdf, all excel formulas pdf free download, all excel formulas with examples, all excel formulas pdf in hindi, all excel formulas and functions, all excel formulas in hindi, all excel formulas with examples pdf, excel formula multiply, excel formula minus, excel formula mcq, excel formula maker, excel formula multiplication, excel formula meaning, excel formula match, excel formula multiply two columns, m s excel formulas pdf, m s excel formulas in hindi, m s excel formulas in hindi pdf download, m s excel formula list in hindi, excel m percentage formula, mm to m excel formula, excel m average formula, m s office excel formulas, excel formula number to words, excel formula not working, excel formula number to words indian rupees, excel formula not showing result, excel formula number, excel formula not calculating, excel formula name, excel formula not equal to, in excel formula, in excel formula starts with, Keywords , excel marksheet formula, excel marksheet grade formula, excel marksheet percentage formula, excel marksheet download, excel marksheet rank formula, excel marksheet result formula, excel marksheet sample, excel marksheet average formula, excel marksheet format, excel marksheet all formula, advanced excel marksheet, ms excel marksheet formulas pdf, ms excel marksheet, ms excel marksheet example, ms excel marksheet grade formula, ms excel marksheet percentage formula, ms excel marksheet pass fail formula, ms excel marksheet formulas pdf in hindi, ms excel marksheet pdf, excel me marksheet banana, excel me marksheet banane ka formula, excel mein marksheet kaise banaye, excel se marksheet kaise banaye, result formula in excel marksheet, excel marksheet chart, excel countif marksheet, ms excel create marksheet, computer excel marksheet, excel marksheet division formula, excel marksheet data, excel marksheet pdf download, download excel marksheet, d in marksheet, ms excel marksheet download, m s excel marksheet formula, excel marksheet example, excel marksheet example download, excel marksheet formula pdf, excel marksheet formula pass fail, excel marksheet file download, excel marksheet format download, excel marksheet formula in hindi, excel marksheet format free download, if formula in excel marksheet, if condition in excel marksheet, if function in excel marksheet, marksheet excel formula, excel marksheet image, excel formulas in marksheet, marksheet in excel download, excel percentage formula in marksheet, marksheet in excel format, marksheet in excel sheet, marksheet in excel sample, in excel marksheet result formula, excel marksheet practice, excel marksheet pdf, excel marksheet kaise banaye, excel me marksheet ka formula, excel marksheet formulas, excel marksheet video, excel marksheet maximum formula, excel marksheet make, excel me marksheet kaise banaye, ms excel me marksheet banana in hindi, microsoft excel marksheet formula, ms excel marksheet rank formula, excel me marksheet, excel sheet of marksheet, excel formulas of marksheet, marksheet on excel, excel marksheet photo, excel marksheet pattern, excel par marksheet kaise banaye, ms excel marksheet questions, excel marksheet remark formula, ms excel marksheet result formula, excel marksheet student, excel school marksheet template, ms excel student marksheet, excel marksheet total formula, excel marksheet template, excel marksheet table, ms excel marksheet template, ms excel marksheet format, marksheet excel template, marksheet using excel, prepare marksheet in excel, prepare marksheet in ms excel, making marksheet in excel, marksheet in excel, excel marksheet with formula, ms excel marksheet formulas, excel 2013 marksheet, excel 2007 marksheet soyab sama.