<div>
All of the solutions were excellent and I will keep them in my excel bag of tricks. &nbsp;In this instance I used y: BillBondo's with the parenthesis.
</div>


All of the solutions were excellent and I will keep them in my excel bag of tricks.  In this instance I used y: BillBondo's with the parenthesis.

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
Using Excel 2013. Windows.<br />
<br />
I have a simple excel question<br />
<br />
I have a number in column A and I want to subtract for example 30 from it.<br />
<br />
What's the easiest way to do that. &nbsp;Do I have to create a blank column for the formula to work. Or can I just do something in excel that subtracts 30 from everything in Column A?<br />
<br />
Thanks<br />
<br />
Rowby<br />
<br />
thanks<br />
<br />
rowby
</div>
</div>


Hello,

Using Excel 2013. Windows.

I have a simple excel question

I have a number in column A and I want to subtract for example 30 from it.

What's the easiest way to do that.  Do I have to create a blank column for the formula to work. Or can I just do something in excel that subtracts 30 from everything in Column A?

Thanks

Rowby

thanks

rowby

Subtracting in excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.