FORMULA HELP

duckworj

New Member
Hi there

I have information in one cell that will provide information for another cell.

I need excel to show the criteria in the 2nd cell

For example...

If cell 1 has a number ranging from 400-500 then cell 2 should report "3"
If cell 1 has a number ranging from 500-699 then cell 2 should report "2"
If cell 1 has a number ranging from 700 then cell 2 should report "3"
If cell 1 has a number ranging from 9000 then cell 2 shoule report "4"

I need to be able to type a number in cell 1 and it automatically generate a result in cell 2..

Can anyone Help

Thanks

Duckers

Excel Facts

Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
If your first cell is A1

=LOOKUP(A1,{400,500,700,9000;3,2,3,4})

Extended on the lower end...

=LOOKUP(A2,{-9.99999999999999E+307,"";400,3;500,2;700,3;9000,4})

Thanks for your ansas...they worked a treat!¬

I have a question:

I am setting up a system to keep track of resumes being sent out. If I type in one column the date I sent out the resume, how can I get excel to calculate out how to automatically to input the date 6 months from date entered in next column?.

It's for when I enter the "date sent", in the next column it will show me (as a reminder) in the next column the date 6 months from now to resend the resume. As most companies keep resumes on file for only 6 months.

Would anyone know the formula to do that?

Your help would be very much appreciated.

Thanks
Leonard (leonardharrietha@yahoo.ca)

Hi there

You could use...

in follow up cell =then the cell reference for info sent +180(this would give you a time scale of 180 days)

for example a2=a1+180

Hope this helps...

Leonard Harrietha said:
I have a question:

I am setting up a system to keep track of resumes being sent out. If I type in one column the date I sent out the resume, how can I get excel to calculate out how to automatically to input the date 6 months from date entered in next column?.

It's for when I enter the "date sent", in the next column it will show me (as a reminder) in the next column the date 6 months from now to resend the resume. As most companies keep resumes on file for only 6 months.

Would anyone know the formula to do that?

Your help would be very much appreciated.

Thanks
Leonard (leonardharrietha@yahoo.ca)

Check your post of yesterday...Several options were given there

http://www.mrexcel.com/board2/viewtopic.php?t=179490&highlight=

Replies
1
Views
310
Replies
4
Views
335
Replies
3
Views
632
Replies
7
Views
237
Replies
3
Views
395

1,203,396
Messages
6,055,162
Members
444,767
Latest member
bryandaniel5

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back