If Statement
I want to use an if statement. It's been so long since I have used one and forgot how to do it
.
Here is the scenario. I am creating a worksheet that calculates how much money is left on a contract. ie.
Full Contract Amount $26,676.00
Cost Amount Remaining
FY 03/04
March_2004 $469.79 $26,206.21
April $647.25 $25,558.96
May $587.26 $24,971.70
June $597.25 $24,374.45
FY 04/05
July $587.24 $23,787.21
August $587.26 $23,199.95
September $653.00 $22,546.95
October $1,251.68 $21,295.27
November $589.72 $20,705.55
December $589.73 $20,115.82
January_05 $657.08 $19,458.74
February $19,458.74
March $19,458.74
April $19,458.74
The formulas is just Lets say The column to the far left is one then two then three. Well when information is typed into column two, that amount is subtracted from column three (the last dollar amount left over) I want to carry the formula down (just like i have for feb, march, and april) but I don't want the last total to show up. I only want information to appear when the dollar amount for feb is entered. and so on and so forth. Can anyone please help me out. This is driving me nuts. I have spent all day yesterday and a large portion of today trying to figure this out. I've searched and searched but cannot find an answer.
All help is greatly appreciated :wink: