Function Help Please ....
 

Ok this is what I need ... Not sure which calculation to use or how to
set up that calculation ...

****If Cell B17 = 1st on Sheet 1 then I need for it to return a vaule
of 50 on sheet 2

****If Cell B17 = 2nd on Sheet 1 then I need for it to return a vaule
on 100 on sheet2

3rd = 150
4th = 200
5th = 250
6th = 300
7th = 350
8th = 400
9th = 450
10th = 500
Stops here .... So one cell would have to contain all the options
above.

I was thinking I should use a database calculation ... But I am not
sure how to set it up ... Can anyone help with this

I would then copy this calcualtion so that it applys to Column B thru K
- Row 17 -26

__________________________________________________ _______________

UPDATE but still need help ....

I can can get the above to work with the IF command but only up to a
point ....

WORKS -

=IF(Sheet2!B17=1,"50",IF(Sheet2!B17=2,"100",IF(She et2!B17=3,"150",IF(Sheet2!B17=4,"200",IF(Sheet2!B1 7=5,"250",IF(Sheet2!B17=6,"300",IF(Sheet2!B17=7,"3 50",IF(Sheet2!B17=8,"400"))))))))


DOES NOT WORK - And this is what I need.

=IF(Sheet2!B17=1,"50",IF(Sheet2!B17=2,"100",IF(She et2!B17=3,"150",IF(Sheet2!B17=4,"200",IF(Sheet2!B1 7=5,"250",IF(Sheet2!B17=6,"300",IF(Sheet2!B17=7,"3 50",IF(Sheet2!B17=8,"400",IF(Sheet2!B17=9,"450",
IF(Sheet2!B17=10,"500"))))))))))

I get the error after "400" - Can anyone help with this? Should I be
using a different command - If so which one? and how do I set it up?


Thanks in advance


--
SVTF
------------------------------------------------------------------------
SVTF's Profile: http://www.excelforum.com/member.php...o&userid=26532
View this thread: http://www.excelforum.com/showthread...hreadid=397993

if that is your data requirement, increments of 50, why not do something
like this:

=Sheet2!B17*50


--
UofMoo
------------------------------------------------------------------------
UofMoo's Profile: http://www.excelforum.com/member.php...o&userid=26485
View this thread: http://www.excelforum.com/showthread...hreadid=397993

ROFLMAO ... Well wasn't that easy ...

Thank you so much ... I came accross another post that explained why I
was getting the error - Can only have 7 nested "IF's" and they had a
work around - I was just reading how to do it when your repsonse came
in ....


Thank you so much - Worked great - goes to show how much I don't know
about excel. :)


--
SVTF
------------------------------------------------------------------------
SVTF's Profile: http://www.excelforum.com/member.php...o&userid=26532
View this thread: http://www.excelforum.com/showthread...hreadid=397993

:cool: I was thinking of that post too, and just about to rewrite the
idea, but.. then realized!

Glad to have helped ;)


--
UofMoo
------------------------------------------------------------------------
UofMoo's Profile: http://www.excelforum.com/member.php...o&userid=26485
View this thread: http://www.excelforum.com/showthread...hreadid=397993