Need Formula for Adding Extra every 10th line

Mar 11th, 2002, 09:51 AM

I need to add 1 cent to every row in a column, except I need to add 2 cents to every 10th record, then the 11th will be 1 cent above the 10th, etc. I tried an if then statement, but it didn't work. Does anyone have any ideas?

Mark W. · Mar 11th, 2002, 10:00 AM

For values in column A beginning at cell A2 enter...

=A2+IF(MOD(ROW()-ROW($A$2)+1,10),0.01,0.02)

... into B2 and Fill Down.

[ This Message was edited by: Mark W. on 2002-03-11 09:09 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 11th, 2002, 09:51 AM	#1
Guest Posts: n/a	I need to add 1 cent to every row in a column, except I need to add 2 cents to every 10th record, then the 11th will be 1 cent above the 10th, etc. I tried an if then statement, but it didn't work. Does anyone have any ideas?

Mar 11th, 2002, 10:00 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	For values in column A beginning at cell A2 enter... =A2+IF(MOD(ROW()-ROW($A$2)+1,10),0.01,0.02) ... into B2 and Fill Down. [ This Message was edited by: Mark W. on 2002-03-11 09:09 ]