i would like to put marks for each entry in excel.Its like as follows
if entry in A1 cell between 1 and 2 mark should be 10
if entry in A1 cell between 0.9 and 0.5 mark should be 5
if entry in A1 cell is greater than 2 mark should be 15
Please help
if entry in A1 cell between 1 and 2 mark should be 10
if entry in A1 cell between 0.9 and 0.5 mark should be 5
if entry in A1 cell is greater than 2 mark should be 15
Please help