New Contributor

# Help, Excel Spreadsheet Formula w/ Over and Under

Hi,

I have a simple question but I am unsure on how to do it. I am attempting to create a sheet that will read out how many units over/under you are based on what numbers you have inputted vs the standing value. An example is shown below. Any idea how to get this done? I will need this to apply to the entire sheet and not just a few lines.

 Base Count Variance 9.00 4.00 -5.00 12.00 15.00 3.00
3 Replies

# Re: Help, Excel Spreadsheet Formula w/ Over and Under

Let's say Base is column A and Count is column B.

Enter the following formula in C2:

=B2-A2

Fill down by double-clicking the fill handle in the lower right corner of B2.

# Re: Help, Excel Spreadsheet Formula w/ Over and Under

@Hans Vogelaar Thank you! Feel foolish it was so simple. Is it possible to format a table so it will fill automatically as values are entered?

# Re: Help, Excel Spreadsheet Formula w/ Over and Under

If you format the data as a table, and enter the formula

=[@Count]-[@Base]

in C2, then fill down if necessary, Excel will automatically enter the formula as you add new rows to the table.