Search:

JBeaucaire, So my assumption is if my initial input changes from 99, then my lookup value changes to that correct? Forgive me for my ignorance, Can you tell me what 99^99 does in the formula, I...

Thank you very much for your assistance. I would like to create additional columns but I am trying to create the worksheet for another co-worker who wants to leave it as 2 columns.

start with C1 = 1000
B2 = 100, so C2 = 900
B3 = 100, so C3 = 800
B4= 2000, so C4 = 0 (skip since it exceeded value available $'s (800)
B5 = 100, C5 = 700 (look at previous available balance and...

Sorry missed your latter part of the question, I put quotes around the zero because of my unfamiliarity what I'm trying to accomplish.

I would like C2 to remain $0 as no $'s are being applied to that project since it exceeded running available balance.

Need some assistance. I am trying to build a spreadsheet with a running balance. I have a field with the initial $ value (C1), I would like the spreadsheet to check if the column with the $'s being...