Nested IF.. is it the right one to use?

  • Thread starter Thread starter Ctech
  • Start date Start date
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?
 
Use the AND function, not the & 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(D6>A2,D6<B2),C2,IF(AND(D6>A3,D6<B3),C3,"NOT SPECIFIED"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nested IF's 2
How do I invoice a cost to a custom built MS Access Accounting Database? 0
Removal of Zero 4
Formatting question with Round 3
formula needed that rounds to 99 cents 4
Round Up by a factor not by a digit [MROUNDUP(number,multiple)] 8
if val in col3 is one of 13 codes (list), apply factor to val in c 1
Special UV light safely kills airborne flu virus 10

Back
Top