Embedded Files
Lookup Functions
vlookup -Vertical lookup, ek value ko search karta hai aur corresponding value return karta hai.
hlookup -Horizontal lookup, ek value ko search karta hai aur corresponding value return karta hai.
index,match -Combination of INDEX aur MATCH functions, dynamic lookup ke liye use hota hai.
Date and Time Functions
today -Current date return karta hai
now -Current date aur time return karta hai
datedif - Do dates ke beech difference calculate karta hai.
Formulas aur functions
Formulas aur functions
Basic Formulas
sum -Sabhi numbers ka total nikalta hai =sum(A1:A10,,range)
average-Selected numbers ka average nikalta ha =average(A1:A10...deta range)
min -Selected range me sabse chhoti value ko return karta hai =min(deta range )
max -Selected range me sabse badi value ko return karta hai =max(range)
countif -Number of numeric values count karta hai =countif(deta range)
counta - Number of non-empty cells count karta ha =counta(deta cell)
Logical Functions
if -Condition ke basis par value return karta hai. =if(condition, value_if_true, value_if_false)
and -Sabhi conditions true honi chahiye =and(condition1, condition2, ...
or - Kisi bhi condition ka true hona sufficient hai -=or(condition1, condition2, ...)
Microsoft Word
"Explore my LinkedIn profile to see detailed information about my career achievements, projects, and professional network ➡️ view
Page updated
Google Sites
Report abuse