IF question

[dctag]

Hello,

I have been going at this for about 1 1/2 hours now and as rediculous as it must sound I cant figure this out.

I am trying to make a statement like

if d42=1 and g42+j42<=1 then True if not then False

Right now I have =if(d42=1,and,if(g42+j42)>=1.True.False)

I cant figure out what I am doing wrong.

Thank You,
David

 

[Brian from Maui]

Hello,

I have been going at this for about 1 1/2 hours now and as rediculous as it must sound I cant figure this out.

I am trying to make a statement like

if d42=1 and g42+j42<=1 then True if not then False

Right now I have =if(d42=1,and,if(g42+j42)>=1.True.False)

I cant figure out what I am doing wrong.

Thank You,
David

=IF(AND(D42=1,G42+J42<=1),TRUE,FALSE)

 

[dctag]

Thank you very much. I appreciate the help.

 

[PA HS Teacher]

dctag,
If you simply need a TRUE or FALSE, the If statement can be shortened to:

=AND(D42=1,G42+J42<=1)