How can I get a variable answer in a cell?

[Juan]

I am writing a mortgage program and I'd like a (loan amount) cell tha
will give me 80% of the value (from another cell). The balance of tha
figure (loan amount over 80%) should overflow to sent to another cel
for a second loan. It the loan amount cell is below 80% of the valu
cell, then it should just equal that amount.

So what would the code or formula be?

I did this years ago for a payroll program I wrote using all hours ove
40 to calculate overtime.

Thanks for any help provided

 

[Frank Kabel]

Hi
if A1 is your 'value cell' and B1 stores the loan amount
try the following formulas (If I understood you correctly):
1. Cell (C1):
=MIN(B1,0.8*A1)

2. Cell (D1)
=MIN(B1-0.8*A1,0)

 

[Juan]

Thanks Frank, you da' man