IF function Excel | Nested IF function in Excel Urdu/Hindi By Haris khan

IF function and Nested IF function in Excel


IF Function:-
The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. In its simplest form, the IF function says:


IF(Something is True, then do something, otherwise do something else)

So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False

Nested IF Function:-
Using a function as one of the arguments in a formula that uses a function is called nesting, and we’ll refer to that function as a nested function. For example, by nesting the AVERAGE and SUM function in the arguments of the IF function, the following formula sums a set of numbers (G2:G5) only if the average of another set of numbers (F2:F5) is greater than 50. Otherwise, it returns 0.

#IFfunction #nestedIFfunction #NestedIF #excelinhindi #advancedexcel #excellogicalfunction

excel if function text
excel if function multiple conditions
multiple if statements in excel
excel if statement multiple conditions range
how to insert an if function in excel
countif function in excel
excel if contains
ifs function excel
excel if contains partial text


Mzeed videos kay ley iss Channel ko SUBSCRIBE aur LIKE karay ,
Takeh aap tak har vodeo pahunch sakay

Haris khan

website---- https://proebookstore.com/

FACEBOOK
  / 212104595551052  

Twitter https://twitter.com/hariskhn98?lang=en

Linkedin   / haris-khan-337a93109