Multiple IF's Formula Help!!

[snb]

@DocE

Why do you use 'Let' ??

sub M_snb()
  cells(1,12)="170.110.000."& choose(instr("FHSV",left(cells(1,6),1)),"415015","415025","415030","143015")& ".0000.0000.000.000"
end sub

PS.
- most of the time multiple ifs can be replaced by an algorithm that reflects an underlying pattern.
in this case e.g. "4150" & 5*instr(" F HSV",left(cells(1,6),1))
- It might be worthwhile to study systematically every function in Excel, starting with text, information, etc.

[DocAElstein]

Hi snb

.......

sub M_snb()
  cells(1,12)="170.110.000."& choose(instr("FHSV",left(cells(1,6),1)),"415015","415025","415030","143015")& ".0000.0000.000.000"
end sub

........

_ Another one ! !! The ways to do stuff in VBA is never ending!!!
_...............................................

@DocE
Why do you use 'Let' ??

http://www.excelfox.com/forum/showth...page2#post9459
http://www.excelfox.com/forum/f2/spe....html#post9459

_...............................................

........
PS.
- most of the time multiple ifs can be replaced by an algorithm that reflects an underlying pattern.
in this case e.g. "4150" & 5*instr(" F HSV",left(cells(1,6),1))
- It might be worthwhile to study systematically every function in Excel, starting with text, information, etc.

_- Thanks for that. Worth bearing in mind.
_ I hope i get time to check it all out. But it is a rather a lot!!!.... _
_ In the meantime it is great to get help from other, more experienced people.

Alan

P.s. I expect for real ( lots of ) data the VLookUp would still be the best, especially if data may be added later.... although you could write a program to produce the formula string.... But as said... the ways to do stuff in VBA is never ending!