√画像をダウンロード excel or function 258923-Excel or function not working
I am using the averageifs function, and have one column where I need to calculate the average if either of the criteria are true I have tried using the OR function, and tried the curly brackets, but both give me errors =AVERAGEIFS(N1N612,I1I612,{"FL","IF"}) There are more ranges, but the coding for those is fineHow to use IF function in Excel The basic form of IF function in Excel is shown as =IF (logic_test, value_if true, value_if_false) In our case we want to check the sale volumes are Low or not If the value in Cell B2 is equal or less than 80, return the text of "Low", if the value in Cell B2 is bigger than 80, return blankThe OR function returns TRUE if any of its arguments evaluate to TRUE, and returns FALSE if all of its arguments evaluate to FALSE One common use for the OR function is to expand the usefulness of other functions that perform logical tests For example, the IF function performs a logical test and then returns one value if the test e...