How do I do this? Please provide the steps on how to do this properly for all the rows it asks for without having to do entry by entry. Go to cell D7 and enter the following function (DELETE the ' before the equal sign when copying/pasting): =IF($C$4>C7,$C$4-C7,0) Fill the formula down to row 30 (see green cells). Go to cell D8 and enter the following function (DELETE the ' before the equal sign when copying/pasting): =vlookup(D7,$G$7:$H$11,2)