Google Sheets IF & IFS Functions || Hindi
In Google spreadsheet, use the Google Sheets if & ifs function to test multiple conditions. What the ifs Google Sheets does is it checks the conditions and returns a value assigned to the first true condition. In other words, if more than one condition is true, or all the conditions are true, then the Google sheets ifs returns the value given to the first condition that is true.
Let's look at the format of the ifs Google Sheets:
=IFS(condition 1, value 1, [condition 2], [value 2],...)
As with all Google Sheets functions, the ifs function too, starts with the equal-to symbol. IFS, which is the name of the function, then follows. Next to it is the opening parenthesis. After it, specify the first condition, followed by a comma. Then, give a value the Google Sheets ifs should return if the condition is true. All the other attributes that will follow the assigned value are optional.
Take a look at this tutorial, which explains the ifs google sheets with an example.
#if
#ifs
#excel