S
SVTF
Ok this is what I need ... Not sure which calculation to use or how t
set up that calculation ...
****If Cell B17 = 1st on Sheet 1 then I need for it to return a vaul
of 50 on sheet 2
****If Cell B17 = 2nd on Sheet 1 then I need for it to return a vaul
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 option
above.
I was thinking I should use a database calculation ... But I am no
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
- Row 17 -26
_________________________________________________________________
UPDATE but still need help ....
I can can get the above to work with the IF command but only up to
point ....
WORKS -
=IF(Sheet2!B17=1,"50",IF(Sheet2!B17=2,"100",IF(Sheet2!B17=3,"150",IF(Sheet2!B17=4,"200",IF(Sheet2!B17=5,"250",IF(Sheet2!B17=6,"300",IF(Sheet2!B17=7,"350",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(Sheet2!B17=3,"150",IF(Sheet2!B17=4,"200",IF(Sheet2!B17=5,"250",IF(Sheet2!B17=6,"300",IF(Sheet2!B17=7,"350",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 b
using a different command - If so which one? and how do I set it up?
Thanks in advanc
set up that calculation ...
****If Cell B17 = 1st on Sheet 1 then I need for it to return a vaul
of 50 on sheet 2
****If Cell B17 = 2nd on Sheet 1 then I need for it to return a vaul
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 option
above.
I was thinking I should use a database calculation ... But I am no
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
- Row 17 -26
_________________________________________________________________
UPDATE but still need help ....
I can can get the above to work with the IF command but only up to
point ....
WORKS -
=IF(Sheet2!B17=1,"50",IF(Sheet2!B17=2,"100",IF(Sheet2!B17=3,"150",IF(Sheet2!B17=4,"200",IF(Sheet2!B17=5,"250",IF(Sheet2!B17=6,"300",IF(Sheet2!B17=7,"350",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(Sheet2!B17=3,"150",IF(Sheet2!B17=4,"200",IF(Sheet2!B17=5,"250",IF(Sheet2!B17=6,"300",IF(Sheet2!B17=7,"350",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 b
using a different command - If so which one? and how do I set it up?
Thanks in advanc