View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
painter50 painter50 is offline
external usenet poster
 
Posts: 8
Default #NAME? Error??????

=IF(AND('Productions Rates'!C3=0,'Productions Rates'!D3=SF,'Productions
Rates'!H3=0),'Productions Rates'!$R$6)

This works fine till I enter the 'Productions Rates'!D=3=SF,

I receive an error #NAME?. I belive it caused by the SF. Any help to
correct this?
--
Joe