VBA formula

[vio.coman]

Hi everybody,

I've got the following excel formula that I am trying to integrate in a code I am currently using:

=if(J2="GS";"VOL101";if(J2="RE";"VOL100";if(and(J2="AC";K2<0);"VOL101";if(and(J2="SA";K2<0);"VOL101";if(and(J2="RX";K2<0);"VOL101";"VOL100"))))))

As my VBA skills are rather poor, I would really appreciate it if you could give me a hand with that.

Thanks a lot!

regards

[6StringJazzer]

How do you want to integrate it? Do you want code that will provide the same result as this formula, or do you want to put this formula into a cell using VBA? What is the context of your existing code?

[vio.coman]

Hi jeff,

thanks for your reply!
Here's my code:

Please Login or Register  to view this content.

[6StringJazzer]

So you want to assign the formula to a cell? Try this. by the way you had an extra parenthesis at the end of your formula above.

Please Login or Register  to view this content.

[nigelbloomy]

Your formula works if you put it in like this:

Please Login or Register  to view this content.

Sorry Jeff. You beat me to it.

[vio.coman]

thanks a lot for your input!

it works perfectly

[nigelbloomy]

Glad you got something that worked. That syntax can be confusing when you want to put a quote into a string.

[6StringJazzer]

A quick note on localization: If your configuration of Excel uses semicolons as separators, you have to use semicolons in VBA formula strings.

[nigelbloomy]

You are right Jeff. I forgot to switch them back after I was done testing it.

[vio.coman]

yes, thanks!