IF Function with multiple parameters

[Radeon]

Hi

I am using the following formula but would like to adapt and add to this.

=IF(D3="","",IF(D3<8,100*D3,D3*150))

Where D3*150 is there a way to add in to only do this if 2 parameters are met. D3 higher than 8 and N2 40% and above, if bothe these parameters are met the D3*150.


Thank you in advance for the assistance

 

[AlanY]

try

=IF(D3="","",IF(D3<8,100*D3,if(and(D3>8,N2>40%),D3*150,"")))

 

[Radeon]

Works like a charm. Thank you

 

[Radeon]

If I wanted to add a 3rd parameter say if D3 was greater than 13 then * 200 if N2 was 40% could this be added in or would it cause to many arguments?

Thanks again

 

[tyija1995]

You can nest IF statements for a very long time so 1 more iteration will be not a problem!

Try this:
=IF(D3="","",IF(D3<8,100*D3,IF(AND(D3>13,N2>=40%),D3*200,IF(AND(D3>8,N2>=40%),D3*150,""))))

 

[Radeon]

Brilliant Thanks again