Complex formula with the condition
Please tell me how to make a formula for fulfilling the condition: if the cell value is greater than 10 of the cell value above and below the original one, then the result is A, otherwise-D
2
1 answers
Your condition will be cyclic, so I took a little liberty, and compared the cell on the right with the cells on the top and bottom of the subject
=ЕСЛИ( И(RC[1]-R[-1]C[1]=10; RC[1]-R[1]C[1]=10); "A"; "D")
1
Author: IVsevolod, 2013-08-06 05:46:42