Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() Hi Im making a formula which is to return the a "Reasearch Factor" depending on the "Cost". One sheet contains a table of data whe Costs between "Cost From" and "Cost To" Gives the a certain "Research Factor". On another sheet I made this fomula which is trying to pull out the "Research Factor" depending on the job cost. This is the fomula Im using: =IF(D6'Research Factor'!$A$2&D6<'Research Factor'!$B$2, 'Research Factor'!$C$2, (IF(D6'Research Factor'!$A$3&D6<'Research Factor'!$B$3,'Research Factor'!$C$3))) However it seams that I can't use the "&".. What am I doing wrong? -- Ctech ------------------------------------------------------------------------ Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745 View this thread: http://www.excelforum.com/showthread...hreadid=499707 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Nested Subtotals in Excel 2002 | Excel Discussion (Misc queries) | |||
Why are my nested sub-totals are displaying incorrectly? | Excel Discussion (Misc queries) | |||
Nested IF statements | Excel Worksheet Functions | |||
€śUse of more then 7 nested if statement€ť | Excel Worksheet Functions | |||
€śUse of more then 7 nested if statement€ť | Excel Worksheet Functions |