Droping remainders

donnyp02

New Member
Joined
Dec 5, 2005
Messages
40
How can you drop the remainder of a cell over a certain number, say 40, to another cell? Thanks for all your help guys!
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
or:

mod(a1,40)

...though mod() doesn't quite fit with the over forty element (hence barry's use of max() )
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234

ADVERTISEMENT

give us a detailed, example of what you've got now & what you want the results to look like.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,671
Messages
5,573,583
Members
412,537
Latest member
Mohamed_5966
Top