HELP!! There is an error in this formula and I can't find it!

  • Thread starter Thread starter Tracey
  • Start date Start date
I think you should have a look at HELP, the AND and OR functions. The way
you try it now doesn't make sense to Excel.
You can also write again and explain what you're trying to achieve; there's
a good chance one of us can help you.
 
I think you have a misplaced parenthesis. In addition, you cannot use an IF
function in say, cell D3 to make cell I3 equal to something. If you put the
following formula in I3, I think you'll get the results you want. If not,
please repost with details.

=IF(C3=1,I3=100%,IF(C3=2,0.8,IF(C3=3,1.25,IF(C3=4,0,IF(C3=5,0)))))

HTH
 
If I understand what you are looking for, enter this in cell I3:

=CHOOSE(C3,1,0.8,1.25,0,0)

When you stipulated if C3 is1, I3 = 100%, a cell not formatted to % will
evaluate and display 1.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Back
Top