I need a cell to have a different formula if another in its row shows a certain value.
i,e if A1 is 10 and A2 is 20, A3 must be A2-10 = 10, but this changes as the value in Column 1 changes -> if B1 is 20 and B2 is 50, B3 must be B2-20 = 30 ect.
I need three different possible formulas.
Have been a bit stuck on this and it would save me so much time in work.
If anyone can help, if its even possible, it would be massively appreciated!