what is the code in excel, every 30 number increment 1 number

[kidscentric]

HI All,

I was trying to enter code in excel sheet, I would like to increment 1 number for every 30 number(30,60,90,120,150,180,210....etc). can any one help me

Thanks

kidscentric

 

[NARAYANK991]

Hi ,

Please be a little more specific.

Which cells in a worksheet do you want formulas in ?

What is the input , if any , for these formulas to use ?

What should be the output in these cells ? If you manually enter the outputs for a few cells , it will help in testing the formula.

Narayan