Nested IF's

[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?

[Don Guillett]

for and, look in help index for AND

--
Don Guillett
SalesAid Software
[email protected]
"Ctech" <[email protected]> wrote in
message news:[email protected]...
>
> 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?
>
>
> --
> Ctech
> ------------------------------------------------------------------------
> Ctech's Profile:
> http://www.excelforum.com/member.php...o&userid=27745
> View this thread: http://www.excelforum.com/showthread...hreadid=499717
>

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

--
Kind regards,

Niek Otten

"Ctech" <[email protected]> wrote in
message news:[email protected]...
>
> 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?
>
>
> --
> Ctech
> ------------------------------------------------------------------------
> Ctech's Profile:
> http://www.excelforum.com/member.php...o&userid=27745
> View this thread: http://www.excelforum.com/showthread...hreadid=499717
>