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!