A little help please :)
 

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(B20C20 AND D25C25,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

A little help please :)
 

=IF(AND(B2C2,D25C25),A30,B30)

--
Regards,

Peo Sjoblom

(No private emails please)


"philly" wrote in
message ...

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(B20C20 AND D25C25,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

A little help please :)
 

This might be what you're looking for:
=IF(AND(B20C20,D25C25),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(B20C20 AND D25C25,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

A little help please :)
 

Thank's guys, sorted now :)


--
philly
------------------------------------------------------------------------
philly's Profile: http://www.excelforum.com/member.php...o&userid=29109
View this thread: http://www.excelforum.com/showthread...hreadid=488286