Can somebody please help with an Excel formula?

McGraw · 07-06-2007, 08:35

For every whole thousand in a number it must add 250s in another column.

So, I would like it to work like this:

1075=250 (1*250)
1987=250 (1*250)
3456=750 (3*750)
7890=1750 (7*250)

etc.

Any help would be greatly appreciated.

Thanks.

TheNorm · 07-06-2007, 08:38

Try this:

=INT(A1/1000)*250

where A1 is the cell containing the original number.

McGraw · 07-06-2007, 08:44

Quote:

Originally Posted by TheNorm

Try this:

=INT(A1/1000)*250

where A1 is the cell containing the original number.

Fantastic.

Thanks very much.

TheNorm · 07-06-2007, 09:19

You're welcome.

I'm especially pleased that I beat Cobbydaler to it. No easy task, I can assure you.

**Rob** · 07-06-2007, 10:23

Quote:

Originally Posted by TheNorm

You're welcome.

I'm especially pleased that I beat Cobbydaler to it. No easy task, I can assure you.

Easy to beat him when he hasn't read the thread yet

TheNorm · 07-06-2007, 11:54

Quote:

Originally Posted by Rob

...he hasn't read the thread yet ...

The omnipotence of the mods sometimes makes my hair stand on end...

**Rob** · 07-06-2007, 12:27

Quote:

Originally Posted by TheNorm

The omnipotence of the mods sometimes makes my hair stand on end...

At least you have hair to stand on end - most mods don't have that luxury