How do i compare numbers in cells with formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report I am attempting to automate as much as possible. What I have
done is put in the following:
Cell J is a current %
Cell K is my product type (a number 19,20)
Cell L is =if(k2=19,"65%",if(k2=20,"75%"))
Cell M I want it to tell me whether the % in cell J is more then L, when I
input the formula =if(j2>=L2,"Yes","No") it does not change but if I delete
the formula in L and type a % in it works....HELP
 
Hi nolechik

You are entering your % as text, not as numbers. Excel cannot therefore
compare the 2 entries. =if(k2=19,.65,if(k2=20,.75)) will do the trick
 

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

Cells not adjusting to new Column 1
formula issue between cells 4
Subtotal and IF Formula 1
Bold items within text string 7
Cell Formatting 5
How do I write this formula 1
How do I write this formula in Excel 2003? 1
Conditional formatting in Excel 2010 2

Back
Top