| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i compare numbers in cells with formula
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do i compare numbers in cells with formula
Ditch the double quotees around the percentages
=if(k2=19,65%,if(k2=20,75%)) "nolechik" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do i compare numbers in cells with formula
Thanks a billion!
"Duke Carey" wrote: Ditch the double quotees around the percentages =if(k2=19,65%,if(k2=20,75%)) "nolechik" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do i compare numbers in cells with formula
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 -- ve_2nd_at. Stilfontein, Northwest, South Africa "nolechik" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
| quick way to copy-paste a formula linked to cells in another file | Excel Worksheet Functions | |||
| Formula to delete blank cells across multiple columns? | Excel Worksheet Functions | |||
| adding cells after stripping numbers out of text fields | Excel Discussion (Misc queries) | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
Hybrid Mode
