#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

#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

#NAME? Error??????
 

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.
--
Joe


"Niek Otten" wrote:

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