help with syntax for if and statement

S

snsyg

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
 
B

BenjieLop

snsyg said:
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!
Click to expand...


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

Regards.
 
Top