multiple if or case select

[john55]

Hello guys,

I tried to find a way of having a correct value in cells c14, c15, c16 according to textbox(s) value.
I attached a test file for yr refference.

I appreciate your help!

[buran]

Hi,
If I understand right, you can achieve it without VBA code, just formula

in c14, c15 put

Please Login or Register  to view this content.

in c16:

Please Login or Register  to view this content.

[john55]

thx a lot for yr solution! it works! I want to use it in a large project and I need a vba solution, if I do not find one I'll try to incorporate this one!

[buran]

it's easy to incorporate it in several different ways:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[nilem]

Hi John55,
maybe this

Please Login or Register  to view this content.

[john55]

Thanks both of you!