Nested IF's

C

Ctech

Hi

Im making a formula which is to return the a "Reasearch Factor"
depending on the "Cost".

One sheet contains a table of data where: 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?
 
N

Niek Otten

Please post to one group only, or if you really need to post to more, do it
in one post, so they will be marked "answered" in all groups. The way you do
it now people spend time answering questions which already have been
answered in another group.

See my answer in other group.
 
Top