I want the formula to appear in the end result (in the cell like this):

=IF(RC[1]="LAS",RC[-1]*1.136+4,IF(RC[1]="INK",RC[-1]*1.136+3.75,""))

1.136 is the 'margin' variable

3.75 is the 'cost' variable

and 4 is the 'costlaser' variable.

Then I want the above to appear in the cell when it goes through the macro, this works perfectly when inputting directly in the cell, how would be the best way to achieve this without a loop.

Any advice is greatly appreciated, sorry its just I cant seem to get this working, not as straight forward as I first thought.

Also keeping away from any loops, as there's roughy 1,888 rows this must go through, their only good for short amounts of data, would be easier but not exactly efficient.

Thanks for your help so far though,
Jeremy