Excel - problem rounding down

  Dirty Dick 22:18 20 Jun 2009
Locked

I'm running Vista & Exel 2007, and am having problems with a spreadsheet.

I have a cell that has a "Weekly Ammount" (say £225) and a breakdown with 7 seperate days ( say A1 to A14 - being 14 sepertae days) and Cells B1 to B14 - for results of breakdown)I then put in the formula into B1 to divide the £225 by the number of days in a week (7) and then mulitiply by the number of days (A1).

The result has a figure ( say £32,14 ) but I want to round this down to the nearest £5.

Is there any way of making a formula (or any other way) of doing this?

Thanx

DD

  VoG II 22:57 20 Jun 2009

Try

=FLOOR(B1,5)

  Dirty Dick 23:09 20 Jun 2009

Thanx VoG™ , works fine

Don't you ever sleep !!

DD

  Dirty Dick 17:00 07 Nov 2010

I'm running Excel 2007 and am struggling with a a formula.

I have a column that adds up the number of days. I then have a formula that calculate weeks (ie A1/7) biu this gives me a decimal figure.

Is there a way I can calculate full weeks and remaing days?

Many Thanx

DD

  Dirty Dick 17:01 07 Nov 2010

in old thread !!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Microsoft Paint set to die after 32 years

Mac power user tips and hidden tricks

Comment désactiver la saisie intuitive et paramétrer votre clavier ?