#NAME? Error??????

[painter50]

=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?

 

[Niek Otten]

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

 

[painter50]

Thanks Niek:

It worked. The SF is for SQUARE FOOT. I am working on a spreadsheet for
estimating interior and exterior painting. I sure i will more issues.
Thanks for your help.