FORMULA HELP

[duckworj]

Hi there

I need help please

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

 

[barry houdini]

If your first cell is A1

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

 

[Aladin Akyurek]

Extended on the lower end...

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

 

[duckworj]

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

 

[Leonard Harrietha]

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)

 

[duckworj]

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...

 

[NBVC]

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=