# Multiple If statements

#### damian_r

##### Active Member
Hi

Can anyone help me with why this statement dosen't work

=((IF(D102<0,"Therefore no infill reqiured",),(IF(AND(D102>0,D102<D32),"Therefore a half infill is reqiured",),(IF(AND(D102>=D33,D103<D31),"Therefore a full infill is required","")))))

All i'm getting is a #VALUE return
Thanks

Damain

### Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

#### Lewiy

##### Well-known Member
I’m not sure exactly what you are trying to do, but does this do what you want?:
Code:
``=IF(D102<0,"Therefore no infill reqiured",IF(AND(D102>0,D102=D33),D103))``

If not, can you explain in plain language the logic you are trying to apply?

#### Jonmo1

##### MrExcel MVP
Use code tags, can't see your whole formula.

Code:
``[code]formula here``
[/code]

#### NBVC

##### Well-known Member
Hi

Can anyone help me with why this statement dosen't work

=((IF(D102<0,"Therefore no infill reqiured",),(IF(AND(D102>0,D102<D32),"Therefore a half infill is reqiured",),(IF(AND(D102>=D33,D103<D31),"Therefore a full infill is required","")))))

All i'm getting is a #VALUE return
Thanks

Damain

Try:

Code:
``=((IF(D102<0,"Therefore no infill reqiured",IF(AND(D102>0,D102<D32),"Therefore a half infill is reqiured",IF(AND(D102>=D33,D103<D31),"Therefore a full infill is required","")))))``

#### damian_r

##### Active Member
Ahh, that post worked well, let's try again!!

Basically i'm tryingto get 3 IF statements in a single line.
Here they are individually:-
=IF(D102<0,"Therefore no infill reqiured","")
=IF(AND(D102>0,D102<D32),"Therefore a half infill is reqiured","")
=IF(AND(D102>=D33,D103<D31),"Therefore a full infill is required","")

Damian

#### Jonmo1

##### MrExcel MVP
Code:
``=IF(D102<0,"Therefore no infill reqiured",IF(AND(D102>0,D102<D32),"Therefore a half infill is reqiured",IF(AND(D102>=D33,D103<D31),"Therefore a full infill is required","")))``

#### NBVC

##### Well-known Member
See my post.... I think that should do it.

#### damian_r

##### Active Member
Thansk to all for your help, i'll give it a go now!

Replies
5
Views
212
Replies
4
Views
128
Replies
1
Views
314
Replies
3
Views
620
Replies
1
Views
286

1,191,682
Messages
5,987,987
Members
440,124
Latest member
dippy_egg

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back