| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using a value from a list in an IF formula
Im trying to use a value(which is a word ,not a number) in an IF formula but
its not working Ex: =IF(C17="TRANSFER",C18*0.005,0) TRANSFER is in a dropdown as part of a list. Any help would be greatly appreciated!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using a value from a list in an IF formula
I just tested your formula and it works whether there is a drop down or not.
Are you sure that the "TRANSFER" in your formula matches the value in the drop-down? Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "johnnyz197034" wrote: Im trying to use a value(which is a word ,not a number) in an IF formula but its not working Ex: =IF(C17="TRANSFER",C18*0.005,0) TRANSFER is in a dropdown as part of a list. Any help would be greatly appreciated!!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using a value from a list in an IF formula
Are you sure there are no leading/trailing spaces in that list?
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "johnnyz197034" wrote in message ... Im trying to use a value(which is a word ,not a number) in an IF formula but its not working Ex: =IF(C17="TRANSFER",C18*0.005,0) TRANSFER is in a dropdown as part of a list. Any help would be greatly appreciated!!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using a value from a list in an IF formula
The formula works ,but its not returning the correct value...When transfer is
in the cell it inputs a 0 result rather than performing the calculation. "Dave F" wrote: I just tested your formula and it works whether there is a drop down or not. Are you sure that the "TRANSFER" in your formula matches the value in the drop-down? Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "johnnyz197034" wrote: Im trying to use a value(which is a word ,not a number) in an IF formula but its not working Ex: =IF(C17="TRANSFER",C18*0.005,0) TRANSFER is in a dropdown as part of a list. Any help would be greatly appreciated!!! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using a value from a list in an IF formula
Im not sure what that means. Can u ellaborate for me please?
"Bob Phillips" wrote: Are you sure there are no leading/trailing spaces in that list? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "johnnyz197034" wrote in message ... Im trying to use a value(which is a word ,not a number) in an IF formula but its not working Ex: =IF(C17="TRANSFER",C18*0.005,0) TRANSFER is in a dropdown as part of a list. Any help would be greatly appreciated!!! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using a value from a list in an IF formula
When I enter TRANSFER in any other cell it works.
"Dave F" wrote: I just tested your formula and it works whether there is a drop down or not. Are you sure that the "TRANSFER" in your formula matches the value in the drop-down? Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "johnnyz197034" wrote: Im trying to use a value(which is a word ,not a number) in an IF formula but its not working Ex: =IF(C17="TRANSFER",C18*0.005,0) TRANSFER is in a dropdown as part of a list. Any help would be greatly appreciated!!! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using a value from a list in an IF formula
He means: are there spaces either before or after the text in the drop down
list? Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "johnnyz197034" wrote: Im not sure what that means. Can u ellaborate for me please? "Bob Phillips" wrote: Are you sure there are no leading/trailing spaces in that list? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "johnnyz197034" wrote in message ... Im trying to use a value(which is a word ,not a number) in an IF formula but its not working Ex: =IF(C17="TRANSFER",C18*0.005,0) TRANSFER is in a dropdown as part of a list. Any help would be greatly appreciated!!! |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using a value from a list in an IF formula
I have a dropdown list in the cell above which requires more space to fit the
entire word in and I have the cell with "TRANSFER" aligned to the right of the cell. I have tried to change the alignment to the left and the center with no results. In the dropdown list itself the choices are aligned to the left, so there are spaces after the text. "Dave F" wrote: He means: are there spaces either before or after the text in the drop down list? Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "johnnyz197034" wrote: Im not sure what that means. Can u ellaborate for me please? "Bob Phillips" wrote: Are you sure there are no leading/trailing spaces in that list? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "johnnyz197034" wrote in message ... Im trying to use a value(which is a word ,not a number) in an IF formula but its not working Ex: =IF(C17="TRANSFER",C18*0.005,0) TRANSFER is in a dropdown as part of a list. Any help would be greatly appreciated!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for producing one list from another ! | Excel Worksheet Functions | |||
| formula drop down list | New Users to Excel | |||
| Is there a list of what certain symbols mean in a formula? | Excel Discussion (Misc queries) | |||
| list formula for dates | Excel Worksheet Functions | |||
| How can I add a new formula to Excel formula list | Excel Worksheet Functions | |||
Linear Mode
