Thread: IF - returns name error
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bondi
 
Posts: n/a
Default IF - returns name error
Hi
Try this,

=IF(I2="ABCD",K2,0)

With text you have to inclose it in qutation marks otherwise Excel
thinks it is a name in the sheet and can't find it.

Regards,
Bondi

Reply With QuoteReply With Quote