simple IF statement

Hi Doug,

That almost works, the problem i have with it is lets say the value of the home is 500,000, they have no first mortgage, and the 2nd is 50,000. H3 ends up showing $50,000 when it should be 0. It should be 0 because the home is worth 500,000, and they only owe 50,000, so none of the 50,000 is at risk. The equation works fine if the first and second mortgage is greater than the home value, but i need to cover 3 possibilities. the 1st possibility is being there is no risk to the 2nd mortgage, the 2nd possibility is that there is some risk to the 2nd, and the 3rd is that the entire 2nd mortgage is at risk.

::Edit:: I was thinking the equation would be something along the lines of =IF(G3>F3,(IF(G3>F3,F3,G3)),0) but some how i have to tell the first IF statement that if G3<F3 then to put F3's value. Basically if G3 less than 0, then H3 should show 0. If G3 is greater than 0 but less than F3, H3 should show G3's value. If G3 is greater than F3, then H3 should show F3's value. ::/Edit::

::Edit 2:: I almost have it. =IF(G3>F3,(IF(G3>F3,F3,G3)),(IF(G3<F3,G3,0))) works except if G3 goes below 0. If G3 becomes a negative number, H3 shows that negative number. How do i tell Excel to show a value of 0 if G3 is a negative number? ::/Edit2::

Sorry if this is confusing, its not the easiest thing to explain, but i do greatly appreciate all the help.

Thanks again,

Joe