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