I have an IF/and formula set up to show calculated payments based off the equipment cost and linked to check boxes so when the boxes were checked, it showed the payment that corresponded. If no boxes were checked, no value showed up. Originally it was just an IF formula and it worked great. I had to add an extra condition to the formula which is why the formula is now an if/and formula. With the extra condition added, those cells always show a value whether the check box is checked or not. Any ideas how to fix this?

Here is a sample of the formula:
=(IF(AND($A18>0,B$17>0,$H$20=2),IF(Inputs!$B$8>=75000,Inputs!$B$8*Inputs!$E79,IF(Inputs!$B$8>=50000,Inputs!$B$8*Inputs!$D79,IF(Inputs!$B$8>=15000,Inputs!$B$8*$C79,Inputs!$B$8*Inputs!$B79))),IF(Inputs!$B$8>=75000,Inputs!$B$8*Inputs!$O79,IF(Inputs!$B$8>=50000,Inputs!$B$8*Inputs!$N79,IF(Inputs!$B$8>=15000,Inputs!$B$8*$M79,Inputs!$B$8*Inputs!$L79)))))

The check boxes put the values in cells A18, B17. H20 is set up as a radio button so there is always a value present.

The earlier formula that worked was:
=IF(AND($A18>0,B$17>0),IF(Inputs!$B$8<15000,Inputs!$B$8*Inputs!$B71,IF(Inputs!$B$8>49999.99,Inputs!$B$8*Inputs!$D71,Inputs!$B$8*Inputs!$C71))," ") (it is missing the logic for cell H20)

I am pretty sure it is not working because h20 is set up as a radio button. For the purposes of the spreadsheet, I need to keep it this way so is there an addition I can make to the formula to account for this?

Any help would be much appreciated!!