Incremental Addding

Hello Everyone,
I'm taking a Business Analysis Class and I need some help for one of my projects.


We are doing expenses and revenue for a daycare on excel.
I need to add $100 for every 5 children.
What formula should I use? I can't have it hardwired in.. so I'm trying to figure out how to add that for every 5 kids. Like, 0-5 kids the expense would be 100, 6-10 kids the expense would be 200.. and etc.
Please please please help me.. It's a group project and no one else in my group knows how to use excel at all

Thank you!

Katie

Hi Katie,

Try if this works. Enter 100 in A1. In A2, enter =IF(MOD(ROW(),5)=1,A1+100,A1). Then drag A2 to other cells in the column.

Regards,
Sindhu