Newbies Bermando Posted April 27, 2006 Newbies Share Posted April 27, 2006 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. Link to comment Share on other sites More sharing options...
Raybaudi Posted April 27, 2006 Share Posted April 27, 2006 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; "" ) Link to comment Share on other sites More sharing options...
Newbies Bermando Posted April 27, 2006 Author Newbies Share Posted April 27, 2006 Thank you so much, It worked perfectly Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6573 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now