Excel - problem rounding down

  Dirty Dick 22:18 20 Jun 09
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 09

Try

=FLOOR(B1,5)

  Dirty Dick 23:09 20 Jun 09

Thanx VoG™ , works fine

Don't you ever sleep !!

DD

  Dirty Dick 17:00 07 Nov 10

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 10

in old thread !!

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

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now