Excel 2007 : Exel problem

**Jackass66** · 04-23-2009, 02:59 AM

Hello

I have this little problem with exel. I was just wondering is it even possible to do?? Or am I just wasting my time.

if there is a number 25-70 in B1 then number 50 comes to A1 and if there is a number 70-150 in B1 then number 100 comes to A1 and if there is a number 150-250 in B1 then number 200 comes to A1.

**DonkeyOte** · 04-23-2009, 03:06 AM

Yes you can use LOOKUP

=IF(N(B1)>=25,LOOKUP(B1,{25,70,150},{50,100,200}),0)

**Jackass66** · 04-23-2009, 03:17 AM

Originally Posted by DonkeyOte

Yes you can use LOOKUP

=IF(N(B1)>=25,LOOKUP(B1,{25,70,150},{50,100,200}),0)

What does that N mean =(N(B1) . I copied this to my A1 but it says its incorrect.

**DonkeyOte** · 04-23-2009, 03:20 AM

Our regional settings will be different (I'm UK) and the functions may need to be translated if you're running in Finish language... I've attached a file with working example - when you open on your own machine the functions should translate automatically...

**Jackass66** · 04-23-2009, 03:42 AM

Originally Posted by DonkeyOte

Our regional settings will be different (I'm UK) and the functions may need to be translated if you're running in Finish language... I've attached a file with working example - when you open on your own machine the functions should translate automatically...

thank yo very much I opened that with my own exel and it tranlated it to finnish. thanks!

**DonkeyOte** · 04-23-2009, 03:44 AM

No problem - I've added a link to my signature detailing a useful function Translation listing... might come in handy.

**mudraker** · 04-23-2009, 08:38 AM

Jackass66

Please take a couple of minutes and read ALL the Forum Rules then edit your thread title by following the instructions in the rules (Rule 1) so that it better discribes your problem/request

**NBVC** · 04-23-2009, 08:43 AM

Originally Posted by DonkeyOte

No problem - I've added a link to my signature detailing a useful function Translation listing... might come in handy.

Hey DonkeyOte,

Neat idea to add all those links to your signature.. makes it easier than constantly looking for them in your bookmarks and attaching them to specific threads...