Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiplying fractions
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiplying fractions
It looks to me that what you are doing is *dividing* by the fraction. If a1
is your answer, and b1 is the fraction, try: =a1/b1 If that's correct, the only issue is what you want when the answer is zero, so try: =if(a1=0,"<20",a1/b1) Regards, Fred "Clubber2010" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiplying | Excel Worksheet Functions | |||
Get rid of #VALUE, after multiplying | Excel Worksheet Functions | |||
Multiplying | Excel Worksheet Functions | |||
Multiplying | Excel Discussion (Misc queries) | |||
Multiplying in a row | Excel Discussion (Misc queries) |