exceluseratcci
New Member
- Joined
- Nov 25, 2002
- Messages
- 33
Actual Expense - Plan Expense = Variance
If Actual Expense has no entry, I don't want a result to show in the Variance cell (I want it to be blank), but if Actual Expense has entry of 0, I do want it to show the difference in the Variance cell.
Tried if formula -- If Actual Expense > 0, Actual Expense - Plan Expense, other "" but obviously if Actual Expenses = 0, it shows blank. If I change to If Actual Expenses >=0, then it shows a result in Variance cell even when Actual Expenses has no entry.
How can I make it show result in Variance cell only if a 0 or greater is entered into Actual Expenses cell, but show blank Variance cell if no entry has been made to Actual Expenses?
Thanks
If Actual Expense has no entry, I don't want a result to show in the Variance cell (I want it to be blank), but if Actual Expense has entry of 0, I do want it to show the difference in the Variance cell.
Tried if formula -- If Actual Expense > 0, Actual Expense - Plan Expense, other "" but obviously if Actual Expenses = 0, it shows blank. If I change to If Actual Expenses >=0, then it shows a result in Variance cell even when Actual Expenses has no entry.
How can I make it show result in Variance cell only if a 0 or greater is entered into Actual Expenses cell, but show blank Variance cell if no entry has been made to Actual Expenses?
Thanks