Thread: Setting up an IF function using a name rather than a number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
karenhvb karenhvb is offline
external usenet poster
  
Posts: 1
Default Setting up an IF function using a name rather than a number
I want to set up formulas such as:
=IF(E7='Smith',F7,0)
=IF(E7='Jones',F7,0)
but it isn't working. Do I need a numerical value in the "logical test"?


Reply With QuoteReply With Quote