help with syntax for if and statement

's Computer Specifications

hello all,

i am having trouble figuring out the syntax for an if / and statement.

this works =(IF(A1=0,"Input Required",B1))

here's the logic i want: IF cell A1=0 AND cell A2<=350000 THEN return
cell value of "Input Required" ELSE A3.

i know this is a basic if and statement, but i just can't get th
syntax figured out.

any ideas?

thanks

--
snsy
-----------------------------------------------------------------------
snsyg's Profile: http://www.excelforum.com/member.php...nfo&userid=523
View this thread: http://www.excelforum.com/showthread.php?threadid=47299

's Computer Specifications

snsyg Wrote:
> hello all,
>
> i am having trouble figuring out the syntax for an if / and statement.
>
> this works =(IF(A1=0,"Input Required",B1))
>
> here's the logic i want: IF cell A1=0 AND cell A2<=350000 THEN return a
> cell value of "Input Required" ELSE A3.
>
> i know this is a basic if and statement, but i just can't get the
> syntax figured out.
>
> any ideas?
>
> thanks!

=IF(AND(A1=0,A2<=350000),\"INPUT REQUIRED\",A3)

Regards.

--
BenjieLop

------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=472997

's Computer Specifications

thanks BenjieLop, it worked perfectly

--
snsy
-----------------------------------------------------------------------
snsyg's Profile: http://www.excelforum.com/member.php...nfo&userid=523
View this thread: http://www.excelforum.com/showthread.php?threadid=47299

's Computer Specifications

You are welcome ... thanks for the feedback.

Regards

--
BenjieLo

-----------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...fo&userid=1101
View this thread: http://www.excelforum.com/showthread.php?threadid=47299

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
if statement syntax help	OfficeManager	Microsoft Excel Worksheet Functions	5	23rd Jul 2008 09:09 PM
select statement into if statement in an event code (syntax error	=?Utf-8?B?dG90YQ==?=	Microsoft Access VBA Modules	1	12th Dec 2004 12:13 PM
Statement syntax	=?Utf-8?B?SmVhbm5pZQ==?=	Microsoft Access Reports	9	11th Nov 2004 04:06 PM
help with IF statement syntax	=?Utf-8?B?TWlrZSBC?=	Microsoft Word Document Management	4	22nd Jul 2004 06:29 AM
IIF Statement syntax?	=?Utf-8?B?bWFj?=	Microsoft Excel Misc	4	28th Jan 2004 10:57 PM