use of (IF) function in increase number gradually with condition

I have attached one sample file. I have tried it with if function,but i cannot make number increase like 10,20 ,30,40 and 50 how to do that???

Are you happy to copy each block of rows (B2:B6) down the worksheet?

If so, =IF(A2>=100,"",10)*(COUNTIF($B$1:B1,">0")+1) in B2 will give you what you want.

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

In K2 then dragdown

Please Login or Register  to view this content.

hi,

you can use this.

=IF(B2="",0,J1+10)

reg
raj

Excellent solution @nflsales - I prefer the OFFSET version because it can easily adapt to inserted columns etc.

Also liked @kvsrinivasamurthy idea. I would make one change to get rid of the zeros, thus
=IF(A2<>"","",IF(INDEX($A$1:$A1,MATCH(99^99,$A$1:$A1))>=100,N(B1)+10,0))

Good work people!

DAC