Thread: Budget functon
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Jim is offline
external usenet poster
 
Posts: 615
Default Budget functon

If your budget amount is in A1 and your actual amount is in B1, C1 could be:

=IF(B1A1,B1-A1,"")

and D1 could be:

=IF(B1<A1,B1-A1,"")

HTH
Jim

"bankercrystal" wrote:

In a budget I set up, I need one column to calculate if the amount paid is
over the budget amount and another column if it is under the column amount.
I can't figure out how to enter a formula that works in Excel 2003.