Value based on row count

[Miloni]

Hi,

I have a database with few columns and rows based on formulas and the values of each column change at different frequency. For eg :The value in col B changes at every 5 rows. Col P changes at every 50th row. Col P is derived from a formula : 0.0254 * Col B * 0.075. Is it possible to have a formula run in Col P where it does calculate the value based on the formula and value in Col B and display the same value as from row 1 in all rows untill row 49 and when it reaches row 50, it displays the value based on the formula and the value in B 50 ?

any help appreciated..

Thanks

miloni

 

[tweedle]

Something like this maybe...
=IF(ROW()<50,0.0254*$B$1*0.075,0.0254*$B$50*0.075)

place in P1 and fill down

 

[Miloni]

Thanks for looking into it. Haven't tried the formula suggested yet, will let you know if it does work. Sorry for the late response.