Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
result will go to right box
Hello to all!
Maybe you can help me with this: 1.) I'm creating a Performance Appraisal Form and I just want that the sum up points will be directly go to the corresponding points. (e.g. the sum up points is 97pts. then I have in column A11 100-91 so it should be directly go in A11, but if the sum up points will be in 55pts. it will be put in column E11, I have a box of in each column: 100-91, 90-81, 80-71, 70-61, 60-51) I'm getting stuck of what should I do on this. But with your help it will be a great for me. Hoping for your simple solution on this matter. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
result will go to right box
In A10 put 100, B10 put 90, C10 put 80, and so on
Now in Cell A11 add the formula =IF(AND($A$1<=A10, $A$1B10), $A$1, "") Copy it across. The value that you put in cell A1 will land in the appropriate spot... -- HTH... Jim Thomlinson "ED CABE" wrote: Hello to all! Maybe you can help me with this: 1.) I'm creating a Performance Appraisal Form and I just want that the sum up points will be directly go to the corresponding points. (e.g. the sum up points is 97pts. then I have in column A11 100-91 so it should be directly go in A11, but if the sum up points will be in 55pts. it will be put in column E11, I have a box of in each column: 100-91, 90-81, 80-71, 70-61, 60-51) I'm getting stuck of what should I do on this. But with your help it will be a great for me. Hoping for your simple solution on this matter. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
result will go to right box
Hi,
When you say "it should go directly to A11, do you want the cursor to move to A11? If so you will need VBA. How does "I have a box in each column" relate to the question you are asking? Where is this sum up number appearing? What kind of "box" do you have in each column? And by column "100-91" what column do you mean? Cheers, Shane Devenshire "ED CABE" wrote: Hello to all! Maybe you can help me with this: 1.) I'm creating a Performance Appraisal Form and I just want that the sum up points will be directly go to the corresponding points. (e.g. the sum up points is 97pts. then I have in column A11 100-91 so it should be directly go in A11, but if the sum up points will be in 55pts. it will be put in column E11, I have a box of in each column: 100-91, 90-81, 80-71, 70-61, 60-51) I'm getting stuck of what should I do on this. But with your help it will be a great for me. Hoping for your simple solution on this matter. Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
result will go to right box
THANK U SO MUCH JIM!!!!! IT REALLY WORKS....YOU SOLVE MY PROBLEM NOW I CAN
USE IT. MAY GOD BLESS YOU ALWAYS AND DON'T GET TIRED OF SHARING YOUR KNOWLEDGE TO OTHERS LIKE ME. REGARDS, ED CABE =) "Jim Thomlinson" wrote: In A10 put 100, B10 put 90, C10 put 80, and so on Now in Cell A11 add the formula =IF(AND($A$1<=A10, $A$1B10), $A$1, "") Copy it across. The value that you put in cell A1 will land in the appropriate spot... -- HTH... Jim Thomlinson "ED CABE" wrote: Hello to all! Maybe you can help me with this: 1.) I'm creating a Performance Appraisal Form and I just want that the sum up points will be directly go to the corresponding points. (e.g. the sum up points is 97pts. then I have in column A11 100-91 so it should be directly go in A11, but if the sum up points will be in 55pts. it will be put in column E11, I have a box of in each column: 100-91, 90-81, 80-71, 70-61, 60-51) I'm getting stuck of what should I do on this. But with your help it will be a great for me. Hoping for your simple solution on this matter. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup shows result one cell above the expected result | Excel Worksheet Functions | |||
excel result return wrong calcuation result | Excel Worksheet Functions | |||
Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
Importing result from Access query to Excel but the result only c. | Excel Discussion (Misc queries) | |||
vlookup based on random result returns incorrect result | Excel Worksheet Functions |