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!!!

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!!!

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!!!

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!!!

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!!!

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!!!

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!!!

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!!!