software

Hi

Im making a formula which is to return the a quot;Reasearch Factorquot;
depending on the quot;Costquot;.

One sheet contains a table of data whe Costs between quot;Cost Fromquot; and
quot;Cost Toquot; Gives the a certain quot;Research Factorquot;.

On another sheet I made this fomula which is trying to pull out the
quot;Research Factorquot; depending on the job cost.

This is the fomula Im using:

=IF(D6gt;'Research Factor'!$A$2amp;D6lt;'Research Factor'!$B$2, 'Research
Factor'!$C$2, (IF(D6gt;'Research Factor'!$A$3amp;D6lt;'Research
Factor'!$B$3,'Research Factor'!$C$3)))

However it seams that I can't use the quot;amp;quot;..What am I doing wrong?--
Ctech
------------------------------------------------------------------------
Ctech's Profile: www.excelforum.com/member.php...oamp;userid=27745
View this thread: www.excelforum.com/showthread...hreadid=499707Use the AND function, not the amp; operator. You didn't specify what the cell
should be if the last condition wasn't met.
Simplified, you formula could be something like

IF(AND(D6gt;A2,D6lt;B2),C2,IF(AND(D6gt;A3,D6lt;B3),C3,quot;NOT SPECIFIEDquot;))--
Kind regards,

Niek Otten

quot;Ctechquot; gt; wrote in message
...
gt;
gt; Hi
gt;
gt; Im making a formula which is to return the a quot;Reasearch Factorquot;
gt; depending on the quot;Costquot;.
gt;
gt; One sheet contains a table of data whe Costs between quot;Cost Fromquot; and
gt; quot;Cost Toquot; Gives the a certain quot;Research Factorquot;.
gt;
gt; On another sheet I made this fomula which is trying to pull out the
gt; quot;Research Factorquot; depending on the job cost.
gt;
gt; This is the fomula Im using:
gt;
gt; =IF(D6gt;'Research Factor'!$A$2amp;D6lt;'Research Factor'!$B$2, 'Research
gt; Factor'!$C$2, (IF(D6gt;'Research Factor'!$A$3amp;D6lt;'Research
gt; Factor'!$B$3,'Research Factor'!$C$3)))
gt;
gt; However it seams that I can't use the quot;amp;quot;..
gt;
gt;
gt; What am I doing wrong?
gt;
gt;
gt; --
gt; Ctech
gt; ------------------------------------------------------------------------
gt; Ctech's Profile:
gt; www.excelforum.com/member.php...oamp;userid=27745
gt; View this thread: www.excelforum.com/showthread...hreadid=499707
gt;