After Hours

Ask something
Discussion Locked

Help with using Functions in excel

0 helpful
1 reply

by luketigers

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi, I'm after a hand at sorting out some functions in excel.

I want a column to display a value based on another number. For example, in C3:C12 I have varying numbers from 50 - 120, I want B3:B12 to give each opposite number a value based on the range they fall in. So anything over 105 I want given a value of 1, anything below 105 but over 90 I want given a value of 2, below 90 but over 80 a value of 3 and so on.

I've tried different functions in the function wizard and can't get past one value before it errors out. Appreciate any help, thankyou.

1 reply

by darryl~

With Excel open, click on the "insert function" button under the Formulas tab....
That opens up the dialogue box where you select the function you want.....
Scroll to "IF"...
In the lower lefthand corner of the dialogue box, click on the "Help on this Function" hyperlink....
It explains how to do what you want very well.....even gives examples.

This discussion is closed to new replies.