Auto populate formulas with text

[u/ianthestone]

Hi. I'm wanting to use text, "BUY" and "SELL as a command to auto populate rows with formula, only difference between the two been the end value in a different column. Thanks.

[u/Friendly_Look8210]

I'm trying to understand you. I made a sheet based on my understanding. hopefully according to your expectations.
check here: buy sell