Help, Excel Spreadsheet Formula w/ Over and Under

%3CLINGO-SUB%20id%3D%22lingo-sub-2058612%22%20slang%3D%22en-US%22%3EHelp%2C%20Excel%20Spreadsheet%20Formula%20w%2F%20Over%20and%20Under%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2058612%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20simple%20question%20but%20I%20am%20unsure%20on%20how%20to%20do%20it.%20I%20am%20attempting%20to%20create%20a%20sheet%20that%20will%20read%20out%20how%20many%20units%20over%2Funder%20you%20are%20based%20on%20what%20numbers%20you%20have%20inputted%20vs%20the%20standing%20value.%20An%20example%20is%20shown%20below.%20Any%20idea%20how%20to%20get%20this%20done%3F%20I%20will%20need%20this%20to%20apply%20to%20the%20entire%20sheet%20and%20not%20just%20a%20few%20lines.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%220%22%20width%3D%22192%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2264%22%20height%3D%2220%22%3EBase%3C%2FTD%3E%3CTD%20width%3D%2264%22%3ECount%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EVariance%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E9.00%3C%2FTD%3E%3CTD%3E4.00%3C%2FTD%3E%3CTD%3E-5.00%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E12.00%3C%2FTD%3E%3CTD%3E15.00%3C%2FTD%3E%3CTD%3E3.00%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2058612%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2058662%22%20slang%3D%22en-US%22%3ERe%3A%20Help%2C%20Excel%20Spreadsheet%20Formula%20w%2F%20Over%20and%20Under%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2058662%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F928293%22%20target%3D%22_blank%22%3E%40Andrew_S80%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet's%20say%20Base%20is%20column%20A%20and%20Count%20is%20column%20B.%3C%2FP%3E%0A%3CP%3EEnter%20the%20following%20formula%20in%20C2%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DB2-A2%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFill%20down%20by%20double-clicking%20the%20fill%20handle%20in%20the%20lower%20right%20corner%20of%20B2.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

 

BaseCountVariance
9.004.00-5.00
12.0015.003.00
3 Replies

@Andrew_S80 

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.

@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?

@Andrew_S80 

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.