Nested IFAND Formula?

[Dallas6570]

I have attached an example sheet.
I am trying to create a nested IF(AND formula and not sure what I am missing. In the attachment I explain what I am trying to accomplish.
If there a maximum number of "nesting" allowed in a formula?

Any help would be appreciated...

THank you,

John

[Kaper]

if 3rd step would be IF F5 equals 4 and E1 is greater than 3360 but less than 5040 multiple 86.75*3 ...
Try:

Please Login or Register  to view this content.

See also hint in yellow banner near the top of the page

[Dallas6570]

Kaper, what do I add for the results to show 0 if anything other than 4 is selected...

I really appreciate your time!

[Gregb11]

Maybe I'm not looking this right or have the wrong file, but could this formula work in cell C2 (of the file you attached in the first post)?
=IF(A2=2,86*ROUNDDOWN(D2/300,0),"")

[Kaper]

If you want to show 0 then in solution by Gregb11, write 0 instead of "" and in my solution from post #2 write 0 instead of "F5<>4"

Trying to guess where would you like the output (not obvious for me looking at the file attached) May be in column E? and relate to numbers from in the same row it could be:

Please Login or Register  to view this content.

@Gregb11: Are you sure it shall be ROUNDDOWN - I'm pretty sure ROUNDUP shall be used. As I understand, for say 150 (so between 0 and 300) the result shall be already 1*86, not 0*86

[Gregb11]

@Kaper - oops, you're right - good catch - it should be ROUNDUP.