help with syntax for if and statement

  • Thread starter Thread starter snsyg
  • Start date Start date
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
 
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.
 
Back
Top