Being a total n00b on that, I thought of asking here:
Let's say I have done a simple calculation in one cell (say, =1+1).
Now I want to see the result appearing in another cell depending on the result ( that is, one cell changes if the result is more than 1 ,but less than 2, but another cell if the result is more than 3,but less than 5 and so on....) ... what formula do I use?
Let's say I have done a simple calculation in one cell (say, =1+1).
Now I want to see the result appearing in another cell depending on the result ( that is, one cell changes if the result is more than 1 ,but less than 2, but another cell if the result is more than 3,but less than 5 and so on....) ... what formula do I use?
Comment