# IF question

#### dctag

##### New Member
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

### Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

#### Brian from Maui

##### MrExcel MVP
dctag said:
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

##### New Member
Thank you very much. I appreciate the help.

#### PA HS Teacher

##### Well-known Member
dctag,
If you simply need a TRUE or FALSE, the If statement can be shortened to:

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

Replies
3
Views
56
Replies
14
Views
145
Replies
2
Views
38
Replies
6
Views
190
Replies
6
Views
33