Input the above formula in B2 then select B2 and drag the fill handle to copy the formula down to other cells. Click Home Find Select Go To Special. In Excel for Mac you dont need the parenthesis.
IF AND B240C240PassFail In the above formula if there is a value 40 or greater than in any of the cells B2 C2 AND function will return true and IF will return value Pass.
To see how altering one of the formula values alters the result change the data in cell C1 from 3 to 6 and press Enter on your keyboard. Then click Formulas Trace Dependents. You can do so using the following formula for FIND in excel. As an office automation tool it allows thousands of calculations to be made in just minutes and simplifies day-to-day work tasks.