Nested IF's

Alex501

Board Regular
Joined
Dec 11, 2015
Messages
51
Office Version
  1. 365
  2. 2019
Hi

I'm trying to nest IF functions but Excel says I have too many arguments, I have the following formula;

=IF(H2>=300,120,60,IF(h2<100,0))

What I'm trying to say is that if the value is greater than or equal to 300 then it returns 120 otherwise it returns 60 - however if the value is less than 100 then it returns 0.

I did get a response to this however the post seems to have disappeared.

Thanks

Alex
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

FormR

MrExcel MVP
Joined
Aug 18, 2011
Messages
6,945
Office Version
  1. 365
Platform
  1. Windows
Hi, using nested IFS() that would look like:

=IF(H2<100,0,IF(H2>=300,120,60))
 
Upvote 0

Forum statistics

Threads
1,196,013
Messages
6,012,857
Members
441,736
Latest member
Tkpmm

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
Top