Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula's | Excel Discussion (Misc queries) | |||
formula's | Excel Discussion (Misc queries) | |||
Formula's | Excel Worksheet Functions | |||
IF formula's | Excel Discussion (Misc queries) | |||
formula's | Excel Worksheet Functions |