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)
There isn't a fixed rule/pattern of such. The numbers are independent.
These numbers are fixed numbers based on another piece of work, so standalone numbers.
I hope that makes sense.
Thanks 🙂
These numbers are fixed numbers based on another piece of work, so standalone numbers.
I hope that makes sense.
Thanks 🙂
Could you attach a version of your workbook with the new columns, and with a list of the number of years with the corresponding values to be used? Thanks in advance.
- 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.
MBIn 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?