Thread: Logical Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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