The If Then Calcuation

[Bermando]

I am trying to do a multiple of the if then calcuation.

What I have now...

If ( Number Box = "1" ; "01")

This works great but only for 1 entry. I want to expand the calcuation for numbers 1 to 9.

I tried this...

If ( Number Box = "1" ; "01")

If ( Number Box = "2" ; "02")

If ( Number Box = "3" ; "03")

And so on up to 9, however I need to find out What to do to make it move on to the next line of if then. Is this possible? Please help if you can.

[Raybaudi]

Hi

when you have to work with multiple "If" statmenth, you can nest them... but is better to use the Case() function.

So, for example:

Case(

Number Box = "1" ; "01";

Number Box = "2" ; "02";

Number Box = "3" ; "03";

...

Number Box = "9" ; "09"

)

or simpler (result text)

Case(

Number Box <= 9; "0"&Number Box;

""

)

[Bermando]

Thank you so much, It worked perfectly