using a value from a list in an IF formula

J

johnnyz197034

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

Dave F

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
 
B

Bob Phillips

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)
 
J

johnnyz197034

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.
 
D

Dave F

He means: are there spaces either before or after the text in the drop down
list?

Dave
 
J

johnnyz197034

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.
 
Top