I'm trying to create a simple formula in excel but having trouble. If I have a column (c1:c100), I want to create a column that contains c*-2. So if c1=3, the new column would equal 1 etc.
How do I word this formula? Thanks.
NMV - It was as simple as I thought, I was just putting brackets where I didn't need to :/.
How do I word this formula? Thanks.
NMV - It was as simple as I thought, I was just putting brackets where I didn't need to :/.
Last edited: