After Hours

General discussion


Help with using Functions in excel

By luketigers ·
Tags: Off Topic
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

You want to use the "IF" ....

by Darryl~ Moderator In reply to Help with using Functions ...

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.

Related Discussions

Related Forums