help with syntax for if and statement

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.ph...info&userid=523
View this thread: http://www.excelforum.com/showthread.php?threadid=47299

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.ph...fo&userid=11019
View this thread: http://www.excelforum.com/showthrea...threadid=472997

thanks BenjieLop, it worked perfectly

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

You are welcome ... thanks for the feedback.

Regards

--
BenjieLo

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