populate a cell based on conditions in other cells

Hello,

I have values being updated automatically in a cell, lets say cell A1.

I would like to put a formula in another cell, lets say cell B1, which checks for a value in A1 and if true, puts some text in another cell, lets say cell C1, D1, E1.


So, B1 will look something like, =IF(A1<20, C1="Buy":D1="0.91":E1="LMT","Do Nothing")

I know above is not a valid formula / format but I put it like that with my intent.

I have been looking online and can't seem to find anything that will do this through a formula. While I would like to do it with a formula, I am open to macros if absolutely needed (the reason I am trying to avoid a formula is because I have few other macros running constantly and updating values, so if I have another macro it might be too much for excel / my computer).

Thank you in advance. This forum is yet to disappoint me!!

Jay

The reason I can't use separate formula in each cell is because its a sheet with complicated macros set up already (totalling 1000 - 2000 lines of macro codes) which I didn't write. So the cells where I need these values, as soon as the condition is met values are erased from those cells. So as soon as condition is fulfilled, I need to get these values on the cells so that an order can be submitted and as soon as that order is submitted those values are erased.

Well if there is no way to do it using formula then I will try macros to copy but is there a way for me to monitor a cell and as soon as a condition is met copy paste values. The part that I am not sure about is, how to constantly monitor the value in a cell as opposed to do it one time. Is it possible to call a macro from a formula as soon as a condition is true (in a if function for example)?

Jay