2 تحميل كتاب الإكسل للمهندسين pdf
3 كتاب مجاني شرح أكثر من 100 دالة من الإكسل
4 كتاب متقدم جدا 👌 كتاب طرق الاهلاك باستخدام دوال الاكسيل
=IF( $A$3:$H$21=$G$1, ROW($A$3:$H$21)-2,"")
The formula =IF($A$3:$H$21=$G$1,ROW($A$3:$H$21)-2,"") is an IF statement in Excel. It checks if the values in the range A3:H21 are equal to the value in cell G1. If they are, then the formula returns the value of ROW($A$3:$H$21)-2. Otherwise, the formula returns an empty string ("").
In other words, the formula is saying: "If the values in the range A3:H21 are equal to the value in cell G1, then return the row number of the range A3:H21 minus 2. Otherwise, return an empty string."
---------------------------------------
Here is how the formula works:
The IF() function is a built-in function in Excel that allows you to test a condition and return a value based on the outcome of the test.
The first argument of the IF() function is the condition that you want to test. In this case, the condition is A$3:$H$21=$G$1. This means that the formula is checking if the values in the range A3:H21 are equal to the value in cell G1.
The second argument of the IF() function is the value that you want to return if the condition is true. In this case, the value is ROW($A$3:$H$21)-2. This means that the formula will return the row number of the range A3:H21 minus 2 if the condition is true.
The third argument of the IF() function is the value that you want to return if the condition is false. In this case, the value is an empty string (""). This means that the formula will return an empty string if the condition is false.
Here is an example of how the formula would work:
Cell A3 contains the value 10.
Cell G1 contains the value 20.
Cell A$3:$H$21 contains the values 10, 20, 30, 40, 50, 60, 70, 80, 90, 100.
When the formula =IF($A$3:$H$21=$G$1,ROW($A$3:$H$21)-2,"") is applied to cell A$3$, the formula returns the value 8. This is because the values in the range A3:H21 are not equal to the value in cell G1.
However, if the value in cell A3 were changed to 20, then the formula would return the value 18. This is because the values in the range A3:H21 would then be equal to the value in cell G1.
=SMALL(IF( $A$3:$H$21=$G$1, ROW($A$3:$H$21)-2,""),ROW(C1))
The formula =SMALL(IF( $A$3:$H$21=$G$1, ROW($A$3:$H$21)-2,""),ROW(C1)) is an Excel formula that returns the smallest number in the range A3:H21 that is equal to the value in cell G1.
The SMALL() function is a built-in function in Excel that returns the smallest number in a range of cells. The first argument of the SMALL() function is the range of cells that you want to search. In this case, the range is A3:H21.
The IF() function is a built-in function in Excel that allows you to test a condition and return a value based on the outcome of the test. The first argument of the IF() function is the condition that you want to test. In this case, the condition is A$3:$H$21=$G$1. This means that the formula is checking if the values in the range A3:H21 are equal to the value in cell G1.
The second argument of the IF() function is the value that you want to return if the condition is true. In this case, the value is ROW($A$3:$H$21)-2. This means that the formula will return the row number of the range A3:H21 minus 2 if the condition is true.
The third argument of the IF() function is the value that you want to return if the condition is false. In this case, the value is an empty string (""). This means that the formula will return an empty string if the condition is false.
The ROW() function is a built-in function in Excel that returns the row number of a cell. In this case, the cell is C1.
Here is an example of how the formula would work:
Cell A3 contains the value 10.
Cell G1 contains the value 20.
Cell A$3:$H$21 contains the values 10, 20, 30, 40, 50, 60, 70, 80, 90, 100.
When the formula =SMALL(IF( $A$3:$H$21=$G$1, ROW($A$3:$H$21)-2,""),ROW(C1)) is applied to cell A$3$, the formula returns the value 20. This is because the value in cell A3 is equal to the value in cell G1, and 20 is the smallest number in the range A3:H21 that is equal to the value in cell G1.
However, if the value in cell A3 were changed to 11, then the formula would return the value 8. This is because the value in cell A3 is not equal to the value in cell G1, and 8 is the smallest number in the range A3:H21.