Formula

 formulas     
Result mate=VLOOKUP($AS$26,$A$2:$Y$52,2,FALSE)
ABCD GRED MATE    =IF(U6<70,"E",IF(U6<100,"D",IF(U6<130,"C",IF(U6<160,"B",IF(U6<=200,"A")))))
400 MARKS PATRAK B MATE NI FORMULA 
=IF(BK6<140,"E",IF(BK6<200,"D",IF(BK6<260,"C",IF(BK6<320,"B",IF(BK6<=400,"A")))))
% MATE     =BM6*100/1800
Final Sareras Gared mate   =IF(BN6<35,"E",IF(BN6<50,"D",IF(BN6<65,"C",IF(BN6<80,"B",IF(BN6<=100,"A")))))
Patrak A mate ni formula =COUNTIFS(C7:V7,"√")
Pagar bill mate =ROUND(K4*119/100,0)

બે કોલમ ભેગી કરવા માટે 
=concatenate(A2," ",B2)
=B2&" "&E2

બે કોલમ છૂટી પાડવામ માટે 
Date Difrence

=DATEDIF("12/12/1986",TODAY(),"y")&" years,"& DATEDIF("12/12/1986",TODAY(),"ym") &" month(s), "& DATEDIF("12/12/1986",TODAY(),"md")&" Days"
=DATEDIF("12/12/1986",TODAY(),"y")
=DATEDIF("12/12/1986",TODAY(),"m")
=DATEDIF("12/12/1986",TODAY(),"d")
www.pwnyoutube.com/watch?v=9yZDsep3IBA
www.ssyoutube.com/watch?v=9yZDsep3IBA
magic youmagictube
ssyoutube
keepvid.com




ċ
Mihirkumar,
Nov 10, 2015, 10:09 AM
Ĉ
Mihirkumar,
Aug 1, 2016, 1:10 PM
ċ
Mihirkumar,
Nov 10, 2015, 10:09 AM
ĉ
Mihirkumar,
Dec 11, 2015, 9:24 AM
ĉ
Mihirkumar,
Nov 15, 2015, 9:33 AM
Comments