Practically every food you buy in a store for consumption by humans is genetically modified food. There are no wild, seedless watermelons. There's no wild cows.
My question is, i need an if statement to assign 4 different numbers if the number in the reference cell is greater then or less then a certain number. (00-39, 40-74, 75-94, 95-99) Answer from Richard Rost:
You could use a complex IF statement, but you might be better off with a VLOOKUP statement. Check out this tutorial:
You can use the VLOOKUP or HLOOKUP function.
VLOOKUP is a powerful function in Microsoft Excel that allows you to look up a value from another spreadsheet - or a smaller subtable (lookup table).
See this FREE tutorial for help with VLOOKUP:
http://599cd.com/tips/excel/vlookup/?key=BlFAlEx
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.
