If formula problem

[nossern]

Hey ppl!

I am having a prolem using the if formula. I have excel 2003.

Column A expresses values ranging from 0 to 4
column B expresses another value
then i have made new columns that correlates with column A, that is lets say column C 1,5-2
column D 2-2,5
column E 2,5-3 etc

I want to make a formula in cells of columns C through E that gives me the value found in Column B if column A is for instance between 1,5-2?!?!

anyone knows, really struggeling over her

-noss

[martindwilson]

Attach a sample workbook.

When you are in Advanced reply, click on the paperclip to open the upload window.

View Pic