View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default #NAME? Error??????

Maybe you mean
="SF"
including the quotes?
Otherwise, what is "SF" supposed to mean?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"painter50" wrote in message
...
=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