Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|