Hi all.
I have a time series in column A, a condition in column B and result in column C. If a condition in column B is greater than -50, then result in column C should be equal to column A. However, if criteria in column B reaches -50 or below, then result in column C is 10 times greater than in column A. Now comes the hard part: next cells in column C should also give a result that is 10 time greater than in corresponding cell in column A until critera in column B reaches 0. I've made an example in a sheet and desired result in column C.
Your help is greatly appreciated!
test2.xlsx
Bookmarks