Hello, I am relatively new to the IF function and am stumped at this point. I have this statement working:

=b25*294+IF(b25<1,b25*0,b26)+if(b25=3,(if(b8>300,(if(b26>5400,5400-b26,))))

I would like to add logic like this:

if(b25=2,(if(b8>200,(if(b26>3600,3600-b26)))))

what I am trying to accomplish is a ceiling for the cell based on the value in b25. I have tried adding the b25=2 at the end of the b25=3 statement using +, tried it prior as well, neither is giving the cell value that I desire.

any help would be appreciated

smkingun