Getting info from an IF statement

[fordguy]

I tried searching for this and came close but i of course cant get exce
to be nice , what i have is this

=IF(D49=9,"0",IF(D49=10,"954",IF(D49=11,"1038")))

This part works what i cant get it to do is pull the info from a cell
so it would be like

=IF(D49=9,"b3",IF(D49=10,"b4",IF(D49=11,"b5")))

where has b3 , b4 , b5 has the number i would like to have put int
d49. as a short fix it put the contents of the b3 , b4 and b5 cells i
the above formula but this isnt desired. Hopefully there is a solutio
to this. Or if anyone had a better suggestion. Because as differen
months come along the values change and its easier to change 6 boxe
instead of 15 formulas ,

thank you for your previous hel

 

[JE McGimpsey]

Remove the quotes from around the cell references:

=IF(D49=9,B3,...

 

[fordguy]

Thank you , i knew there had to be away , i usaly find what i am lookin
for in examples and try to customize it to what i need thank you agai