IF Function with multiple parameters

Radeon

New Member
Joined
Jul 25, 2019
Messages
4
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
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
try

=IF(D3="","",IF(D3<8,100*D3,if(and(D3>8,N2>40%),D3*150,"")))
 
Upvote 0
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
 
Upvote 0
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,""))))
 
Last edited:
Upvote 0

Forum statistics

Threads
1,223,897
Messages
6,175,269
Members
452,628
Latest member
dd2

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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