OFFSET with divide and multiply operation

[xdenama]

How to write formula

=A8/B10*100
with add OFFSET function like this 
=OFFSET(A8/B10*100),,,28,)* not working

 

[StephenCrump]

A8/B10*100 is a value. You can offset a reference, but you can't offset a value.

Perhaps you can explain what you are trying to do? Your formula doesn't make any sense.

 

[xdenama]

A8/B10*100 is a value. You can offset a reference, but you can't offset a value.

Perhaps you can explain what you are trying to do? Your formula doesn't make any sense.

Actulally, I want to auto draging this formula for 28 row below without manually drag the formula.
A8/B10*100

 

[StephenCrump]

I'm still not clear what you're doing. Why can't you drag down for 28 rows?

Did you know that you can select a cell and double click the bottom right hand corner to copy down a formula down the length of the previous column?

Are you perhaps looking for VBA code?