To the expert who can decipher this, i am trying to solve an issue on my excel spreadsheet. I will write the formula of which i am trying to achieve and hopefully someone can see where i am going wrong and how i can best fix this.
=if(And(B2<=D1),"1","If"(B2>D1,B2<=D2),"2","if"(B2>D2,<=D3),"3","If"(B2>D3,B2<=D4),"4","")))) and so on if necessary
this formula is to be written in cell F1
Value examples in D1 - 3, D2 - 6, D3 - 9, D4 - 12
Value to be entered in B2 will be between this figures .... say 7
which i hoped would automatically select the number 3 in cell F1 as a result but i keep getting a formula error in the way i am trying to express the formula and my problem.
I someone is smart enough to figure this one out or solve a better way or getting my end result i would be extremely grateful
=if(And(B2<=D1),"1","If"(B2>D1,B2<=D2),"2","if"(B2>D2,<=D3),"3","If"(B2>D3,B2<=D4),"4","")))) and so on if necessary
this formula is to be written in cell F1
Value examples in D1 - 3, D2 - 6, D3 - 9, D4 - 12
Value to be entered in B2 will be between this figures .... say 7
which i hoped would automatically select the number 3 in cell F1 as a result but i keep getting a formula error in the way i am trying to express the formula and my problem.
I someone is smart enough to figure this one out or solve a better way or getting my end result i would be extremely grateful