CAN ANYONE HELP WITH A SPECIFIC FORMULA I NEED?

[christine]

here is what I need and all attempts of writing it have failed.

in cell d3 of worksheet C, I need:

value of b15 of worksheet A only if cell c2 has a value of 1
worksheet A is called pricing

one formula I tried:
=index(if(pricing!$c$2=1, b15... or something like that....

[Zack Barresse]

Hi christine,

How about ...

=IF(Pricing!$C$2=1,B15,"")

HTH

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM



"christine" <christine@discussions.microsoft.com> wrote in message
news:291547A0-0B25-4778-A8A8-DFEDB2F9D1DB@microsoft.com...
> here is what I need and all attempts of writing it have failed.
>
> in cell d3 of worksheet C, I need:
>
> value of b15 of worksheet A only if cell c2 has a value of 1
> worksheet A is called pricing
>
> one formula I tried:
> =index(if(pricing!$c$2=1, b15... or something like that....

[Richard Buttrey]

On Thu, 30 Mar 2006 14:54:01 -0800, christine
<christine@discussions.microsoft.com> wrote:

>here is what I need and all attempts of writing it have failed.
>
>in cell d3 of worksheet C, I need:
>
>value of b15 of worksheet A only if cell c2 has a value of 1
>worksheet A is called pricing
>
>one formula I tried:
>=index(if(pricing!$c$2=1, b15... or something like that....


You didn't say what you wanted returned if C2 is not one. I've assumed
null.

=If(pricing!$c$2=1,Pricing!B15,"")

HTH


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

[Mike T]

The formula for cell D3 of worksheet C should be
=IF(pricing!$C$2=1,pricing!B15,)

if C2 does not equal 1, then the result is empty


"christine" wrote:

> here is what I need and all attempts of writing it have failed.
>
> in cell d3 of worksheet C, I need:
>
> value of b15 of worksheet A only if cell c2 has a value of 1
> worksheet A is called pricing
>
> one formula I tried:
> =index(if(pricing!$c$2=1, b15... or something like that....