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)
I have uploaded 'SAMPLE 2' to my original post. I couldn't seem to attach to this message. Column M shows how long until a person is 68 and what the payment must be. I hope this makes sense. Not the easiest to explain.
Thanks for your help.
MB
Thanks for your help.
MB
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)
See the series of tutorials that begins at Formulas and Functions
- 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?