Hi guys,I am very slowly getting to grips with excel,and I am totally stuck on a project i am doing.I have a series of 6 cells of numbers, that are calculated to show the average total in a 7th cell,I now want to take the figure from the 7th cell,and to automatically assign a value in an 8th cell,which corresponds to a range of differing values.ie/ if cell 7 =anywhere between 1 and 10 then cell 8 automaticlly assigns x.if cell 7 =anywhere between 11 and 20 then cell 8 automaticlly assigns x.etc
x being = to a range of points,would appreciate any help on layout and formula.
thanks in advance.
x being = to a range of points,would appreciate any help on layout and formula.
thanks in advance.