Multiple If statements

[damian_r]

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

 

[Lewiy]

I’m not sure exactly what you are trying to do, but does this do what you want?:

=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]

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

[code]formula here

[/code]

 

[NBVC]

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:

=((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]

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","")

Your help is appreciated!!

Damian

 

[Jonmo1]

=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]

See my post.... I think that should do it.

 

[damian_r]

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