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