View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
James Ravenswood James Ravenswood is offline
external usenet poster
 
Posts: 143
Default excel formula for markup and profit margin

In B2:
=$A$1*0.05*COLUMNS($A:A) and copy across
In B3:
=$A$1+B2 and copy across
In B4:
=B2 and copy across