Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula's Quif210786 Excel Discussion (Misc queries) 2 September 27th 08 03:51 PM
formula's redwing Excel Discussion (Misc queries) 6 June 18th 08 03:11 AM
Formula's George Excel Worksheet Functions 7 January 26th 06 07:11 PM
IF formula's alice Excel Discussion (Misc queries) 3 January 20th 06 03:42 PM
formula's sunrosejenn Excel Worksheet Functions 1 October 14th 05 01:38 PM


All times are GMT +1. The time now is 07:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"