Logical Formula
Consider the original budget in column A. Any revisions to the original
budget in column B. Entries in column B will be empty until a revision is
made. YTD Actuals will be in column C. The calculation is in column D. In
D1:
=IF(B1="",A1-C1,B1-C1)
--
Gary''s Student - gsnu200736
|