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