Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Excel 2003 - I have a spreadsheet that needs to check a members Age in a
colum, then compare the Age to a set of data to return the proper "rate". I have tried =IF and =LOOKUP and both seem to fail grieviously when I use <= Example: =IF ('WS1'|A1, <=24, 1 and then repeates the <= per each age range break(8 categories to check for true/false). Where in the nurmal if true is going to be a row to apply to, then a second =IF will check salary and assign the Colum. Now I know checking for 8 or more I should use lookup but it seems to fail als |
#2
![]() |
|||
|
|||
![]()
Instead of IF, you could use a VLOOKUP formula to return a value from a
rate table. There are examples in Excel's Help, and he http://www.contextures.com/xlFunctions02.html Or, depending on your data structure, you may need to use an INDEX/MATCH formula. There are examples he http://www.contextures.com/xlFunctions03.html Kenner Costen wrote: Excel 2003 - I have a spreadsheet that needs to check a members Age in a colum, then compare the Age to a set of data to return the proper "rate". I have tried =IF and =LOOKUP and both seem to fail grieviously when I use <= Example: =IF ('WS1'|A1, <=24, 1 and then repeates the <= per each age range break(8 categories to check for true/false). Where in the nurmal if true is going to be a row to apply to, then a second =IF will check salary and assign the Colum. Now I know checking for 8 or more I should use lookup but it seems to fail als -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I check if data in external data range is changed after re | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Automatic cell increment with data from sheet 1 to sheet 2 | Excel Worksheet Functions | |||
sending data from one cell to another (not using copy & paste) | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |