INDIRECT reference
 

Hi. I need to have in say cell A1 a drop down list (which I obtain with the
data validation tool) which shows a list like 0%, 5%, 10%, 15%, etc. so that
people looking at the spreasheet can select their % desired. BUT, while I
would like the numbers to chosse from in the drop down list to be those
above, I really need them to be divided by 12 i.e. (0%/12), then (5%/12),
then (10%/12), etc.
I thought i cd try to do it with the indirect function but I ma not really
sure what the best way to do it. Is?
Any suggestions?
I made be going about it the wrong way as well....
Tx,
Sat

INDIRECT reference
 

Sat,

Can't you simply use =A1/12

--

HTH

Bob Phillips

"saturnin02" wrote in message
...
Hi. I need to have in say cell A1 a drop down list (which I obtain with
the
data validation tool) which shows a list like 0%, 5%, 10%, 15%, etc. so
that
people looking at the spreasheet can select their % desired. BUT, while I
would like the numbers to chosse from in the drop down list to be those
above, I really need them to be divided by 12 i.e. (0%/12), then (5%/12),
then (10%/12), etc.
I thought i cd try to do it with the indirect function but I ma not really
sure what the best way to do it. Is?
Any suggestions?
I made be going about it the wrong way as well....
Tx,
Sat

INDIRECT reference
 

I cd but that is only part of the formula.
But for other reasons, I'd liek to know if there is a way of doing what I
posted below--something like ti I mean....

"Bob Phillips" wrote in message
...
Sat,

Can't you simply use =A1/12

--

HTH

Bob Phillips

"saturnin02" wrote in message
...
Hi. I need to have in say cell A1 a drop down list (which I obtain with
the
data validation tool) which shows a list like 0%, 5%, 10%, 15%, etc. so
that
people looking at the spreasheet can select their % desired. BUT, while
I
would like the numbers to chosse from in the drop down list to be those
above, I really need them to be divided by 12 i.e. (0%/12), then
(5%/12),
then (10%/12), etc.
I thought i cd try to do it with the indirect function but I ma not
really
sure what the best way to do it. Is?
Any suggestions?
I made be going about it the wrong way as well....
Tx,
Sat