Prev: multiple worksheets
Next: Creating a form in Excel
From: painter50 on 6 Mar 2010 17:40
=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
From: Niek Otten on 6 Mar 2010 17:51
Maybe you mean
="SF"
including the quotes?
Otherwise, what is "SF" supposed to mean?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"painter50" <painter50(a)discussions.microsoft.com> wrote in message
news:A17B6C3B-3D4D-4E81-BE24-0BF16B6C0FE1(a)microsoft.com...
> =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

From: painter50 on 6 Mar 2010 18:12
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" <painter50(a)discussions.microsoft.com> wrote in message
> news:A17B6C3B-3D4D-4E81-BE24-0BF16B6C0FE1(a)microsoft.com...
> > =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
>
 | 
Pages: 1
Prev: multiple worksheets
Next: Creating a form in Excel