I'm sure there is a very simple calculation to do this but for some reason i can't see it.

best

Stuart

Let ( [

//a = number from 1 to 5

a = 1 ;

//b = number from 1 to 5

b = 5 ] ;

Choose ( a ;

Choose ( b ; 00 ; 01 ; 02 ; 03 ; 04 )

Choose ( b ; -1 ; 00 ; 01 ; 02 ; 03 )

Choose ( b ; -2 ; -1 ; 00 ; 01 ; 02 )

Choose ( b ; -3 ; -2 ; -1 ; 00 ; 01 )

Choose ( b ; -4 ; -3 ; -2 ; -1 ; 00 )

)

)

ps the 00 are just to make it readable a simple number is all that needs to be returned.

are you sure that's right? -- your missing the zero values in the choose statement.

i.e. Choose( 2 ; 0 ; 1; 2 ) will return 2

Choose( x ; result0 ; result1; result 2...)

got it...

-a + b

your right genx, i always forgot the first choose is 0

or just b-a lol

LOL

Its one of those days

Why must my brain do this to me sometimes.

I remember sitting at school aged 10 and spelling "a", "ay" and thinking i'm sure thats not right but i can't for the life of me work out why.

Don't I know the feeling :)

Out of curiosity, are you seeing this topic as:

Can't see the wood for the trees

I am

Ph&@039il

I was

Phil

I have changed it from Can't to Cant, to preserve this valuable topic for antiquity

Did you actually type an apostrophe in or copy it from somewhere else?

Can't

Well, i assume there is a difference between the topic and the body...

Anywho, was just curious.

I can't get into my head why you do jump all these Choose( hoops when the entire thing can be written this way:

Right("0" & GetAsText(theB-theA);2)

--sd

see what your saying but although its not clear in the example the range could potentially be highter than 9.

don't think the solution could really be any simpler than b-a

best

Stuart

9 what???

--sd

Quote:

ps the 00 are just to make it readable a simple number is all that needs to be returned.

The original example (although functional) was illustrative.

Hence the lack of quotes then!!

--sd