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