Nested IF's

[Alex501]

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

 

[FormR]

Hi, using nested IFS() that would look like:

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

 

[Alex501]

Hi FormR

Worked perfectly, thanks for the help.

Alex