I'm trying to build a basic financial tools sheet for myself. Here's a problem:
Let's make Cell B1 30 times of cell A1 (B1 = 30*A1). However I'm not sure when A1 is a known value or B1 is.
What I need is when I fill 100 in A1, B1 will be filled with 3000 (30xA1) automatically, and if I fill 60 in B1, A1 will be filled 2 (1/30 of B1).
Is it possible?