A little help please :)

[philly]

Hello,

I'm a complete novice when it comes to spreadsheets, so go easy on me please .
I'm doing a little project, but I need a little help.

What I'm trying to do is something like this:
=IF(B20>C20 AND D25>C25,A30,B30)

However, this doesn't work for whatever reason, is there any way I can make this work?

Thank's in advance, Phil.

[Peo Sjoblom]

=IF(AND(B2>C2,D25>C25),A30,B30)

--
Regards,

Peo Sjoblom

(No private emails please)


"philly" <[email protected]> wrote in
message news:[email protected]...
>
> Hello,
>
> I'm a complete novice when it comes to spreadsheets, so go easy on me
> please .
> I'm doing a little project, but I need a little help.
>
> What I'm trying to do is something like this:
> =IF(B20>C20 AND D25>C25,A30,B30)
>
> However, this doesn't work for whatever reason, is there any way I can
> make this work?
>
> Thank's in advance, Phil.
>
>
> --
> philly
> ------------------------------------------------------------------------
> philly's Profile:
> http://www.excelforum.com/member.php...o&userid=29109
> View this thread: http://www.excelforum.com/showthread...hreadid=488286
>

[Ron Coderre]

This might be what you're looking for:
=IF(AND(B20>C20,D25>C25),A30,B30)

Does that help?

***********
Regards,
Ron


"philly" wrote:

>
> Hello,
>
> I'm a complete novice when it comes to spreadsheets, so go easy on me
> please .
> I'm doing a little project, but I need a little help.
>
> What I'm trying to do is something like this:
> =IF(B20>C20 AND D25>C25,A30,B30)
>
> However, this doesn't work for whatever reason, is there any way I can
> make this work?
>
> Thank's in advance, Phil.
>
>
> --
> philly
> ------------------------------------------------------------------------
> philly's Profile: http://www.excelforum.com/member.php...o&userid=29109
> View this thread: http://www.excelforum.com/showthread...hreadid=488286
>
>

[philly]

Thank's guys, sorted now