#NAME? Error??????

  • Thread starter Thread starter painter50
  • Start date Start date
P

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?
 
Maybe you mean
="SF"
including the quotes?
Otherwise, what is "SF" supposed to mean?
 
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.
 
Back
Top