Thread: using a value from a list in an IF formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
johnnyz197034 johnnyz197034 is offline
external usenet poster
  
Posts: 13
Default 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!!!
Reply With QuoteReply With Quote