C
Clubber2010
Hi, i am trying to do something on excel, but cannot for the life of me
figure what formula i should write..
This may help if i explain first -
I have a column with a number in it (the answer)...
I have a column with the fraction 1/20 in it..
Then i want a column that will multiply these 2 columns together
If the answer is 0, it goes down as <20
If the answer is 1, it goes down as 20
If the answer is 2, it goes down as 40 etc
(like it is set out below)...
(0) * (1/20) = (<20)
(1) * (1/20) = (20)
(2) * (1/20) = (40)
This is probably so simple, but I cannot think at all..
In the last column all i keep getting is #NA rather than what i have above!
figure what formula i should write..
This may help if i explain first -
I have a column with a number in it (the answer)...
I have a column with the fraction 1/20 in it..
Then i want a column that will multiply these 2 columns together
If the answer is 0, it goes down as <20
If the answer is 1, it goes down as 20
If the answer is 2, it goes down as 40 etc
(like it is set out below)...
(0) * (1/20) = (<20)
(1) * (1/20) = (20)
(2) * (1/20) = (40)
This is probably so simple, but I cannot think at all..
In the last column all i keep getting is #NA rather than what i have above!