[vip_students] Re: excel

  • From: "roisin.mulligan" <roisin.mulligan@xxxxxxx>
  • To: <vip_students@xxxxxxxxxxxxx>
  • Date: Wed, 24 Sep 2008 11:12:54 +0100

Ger,

What range is your numbers (expenses) in?

Are you using the =sum() function?

Would some of your figures have been mistyped and maybe contain a letter?

If a letter is in a cell which you intend to be numeric, it will not be added in the function.

Roisin

----- Original Message ----- From: "Ger Delaney" <germdelaney2@xxxxxxxxxx>
To: "Paul Traynor" <lists@xxxxxxxxxxxxxxx>
Cc: <vip_students@xxxxxxxxxxxxx>
Sent: Wednesday, September 24, 2008 9:48 AM
Subject: [vip_students] excel



Hi Everyone,
In excel , when I create a house hold budget!!! , afterall the appropiate information and details are in the formulas are applied , for the totals for each month are then added,. the results do not include the first row of out going expences. Any suggestions , recomendations on how to correct this? Also, (this one may be of the same problem) in this project in excel titled income, after all the information is typed in, whenthe totals are added up per month, the firstthree months and the last three months give the correct results, while the middle six months give a negative results ie zero, again, any ideas or recomendations are appreciated, Thanks in advance.

Regards

Ger

********************************************************************

NOTICE: The information contained in this email and any attachments is confidential and may be privileged. If you are not the intended recipient you should not use, disclose, distribute or copy any of the content of it or of any attachment; you are requested to notify the sender immediately of your receipt of the email and then to delete it and any attachments from your system.

NCBI endeavours to ensure that emails and any attachments generated by its staff are free from viruses or other contaminants. However, it cannot accept any responsibility for any such which are transmitted. We therefore recommend you scan all attachments.

Please note that the statements and views expressed in this email and any attachments are those of the author and do not necessarily represent the views of NCBI


********************************************************************




Other related posts: