Forum Discussion
Solved
Formula help
Hi I work on a pc. Excel version 14.0.7268.5000 I need to develop a formula to help with a prediction model I'm working on. In simple terms I need the formula to predict an outcome of either 'Pass...
In H2:
=IF(C2>=VLOOKUP(MAX(F2:G2),$M$2:$N$17,2),"Pass","Fail")
Fill down. (Notice that the formula doesn't use the entire range in columns M and N. Once the value in column N remains the same, the rest isn't needed)
In H2:
=IF(C2>=VLOOKUP(MAX(F2:G2),$M$2:$N$17,2),"Pass","Fail")
Fill down. (Notice that the formula doesn't use the entire range in columns M and N. Once the value in column N remains the same, the rest isn't needed)
Thank you. That's amazing, I would never have got them myself.
Do you have any recommendations for courses I could to develop my skillset on formulas?
Do you have any recommendations for courses I could to develop my skillset on formulas?
See the series of tutorials that begins at Formulas and Functions