convert formula to code please

[d0wnt0wn]

is there a way that I can convert this formula to code? it seems it is too long now and the last part of the formula does not work

=IF(B14="cedar conversion",ROUNDUP(B16/10,0),IF(B14="plywood over shiplap tear off",ROUNDUP(B16/10,0),IF(B14="2 layer plywood over shiplap",ROUNDUP(B16/10,0),IF(B14="3 layer plywood over shiplap",ROUNDUP(B16/10,0),IF(B14="1 layer on cedar tear off",ROUNDUP(B16/10,0),IF(B14="2 layer on cedar tear off",ROUNDUP(B16/10,0),IF(B14="3 layer on cedar tear off",ROUNDUP(B16/10,0),"")))))))

 

[d0wnt0wn]

ok .... the formula works great except I get back to the same problem.... it sees that I have one too many conditions in my formula... because the last one does not work

=IF(OR(B14="Cedar conversion",B14="plywood over shiplap tear off",B14="2 layer plywood over shiplap",B14="2 layer plywood over shiplap",B14="3 layer plywood over shiplap",B14="1 layer on cedar tear off",B14="2 layer on cedar tear off",B14="3 layer on cedar tear off"),ROUNDUP(B16/10,0),"")

 

[d0wnt0wn]

sorry.... seems that excel was glitching out and I had to erase the 3 layer on cedar tear off from the drop down menu and re-write it... now it works... thanks again