Thread: Formula's
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bensum Bensum is offline
external usenet poster
 
Posts: 2
Default Formula's

Please help,

I need to know what formula's to enter to acheive the following results:-

1. I have 4 cells:-

Actual Expense
Budget
£ of budget remaining
% of budget remaining

Currently if my actual expense is greater than my budget, the '£ of budget
remaining' cell returns a minus figure. Rather than the cell showing a minus
figure I would prefer it to just return a zero balance in order that my end
of year figures are correct.

2. Also, another query I have is that to get my '% of budget remaining'
figure I do the following '£ of budget remaining' divide 'budget' and this
returns the answer however, if the budget is zero and therefore the
calculation is dividing by zero I get this messgae '#DIV/0!'. How can I tell
excel to just return a zero percentage?

Many thanks
--
Bensum