Free Microsoft Excel 2013 Quick Reference

# What is the formula for subtracting the sum total of two cells

What is the formula for subtracting the sum total of two cells in nonadjacent
(nonconnecting) cells?

## Related Results

### What is the formula for the sum of numbers from one date to anoth.

In other words, I have a list of dates with hours and costs from January thru
December on one worksheet. I want to have another worksheet calculate the
quarterly numbers including hours, costs, etc. between January 1st and March
31st and then between April 1st and June 30th and so on. What is the formula
for the sum of numbers from one date thru another. I need to divide this one
worksheet into quarters. Thank you!

### What is the formula for dividing a number by 4 in excel

What is the formula for dividing a number by 4 in excel

### What is the formula for rounding a dollar amount to the nearest ni

What is the formula for rounding a dollar amount to the nearest nickel?

### What is the formula to calculate Age when I have Date of Birth?

I am trying to create an Age column based on the DOB (Date of Birth). What
is the formula for the Age Column??

### What is the formula for adding a number of days to an existing dat

Dear all,

If in the cell A1, there is a date 05/04/2005 (i.e. May 4), if in cell B1, I
want add 5 days to the date value in A1, i.e. 05/09/2005. What is the
worksheet formula that I can do this calculation?
Thanks.

Ivan

### What is the formula used to keep track of totals for a column?

I saw somewhere that you could keep track of the totals in a column such as
100|100
200|300
300|600
400|1000
500|1500

I was wondering what the formula for that was and if it could keep track if
you used negatives by subtracting it from the total.

### Re What is the formula for adding multiple numbers in a cell

Hi
Hoping someone can help me, i know it's a really basic thing but i just need
to know how to add multiple numbers to single excel cell. The spreadsheet is
being used for a monthly sales report & i need to add the daily sales figures
to each persons name in the report & have it auto tally each personal totals
over the month.

Thanks
Tony

### What is the formula for the cubed root of

cell a1 = 9
what would the formula be to get the cubed root of the value in cell a1 ?

i found the square root formula "=SQRT(a1) but nothing hs worked yet for
cubed root

thanks

### What would the Formula for P1 be.

Thanks very much.
Assuming that this is a spread sheet. What would the Formula for P1 be.
Question: (H1 X J1) + (L1 X N1) = P1

H J L N P

1 14 X \$50.00 PLUS 2 X \$75.00 = \$850.00

2
3
4
5

### Re What is the formula for adding multiple numbers in a cell

Hi
Hoping someone can help me, i know it's a really basic thing but i just need
to know how to add multiple numbers to single excel cell. The spreadsheet is
being used for a monthly sales report & i need to add the daily sales figures
to each persons name in the report & have it auto tally each personal totals
over the month.

Thanks
Tony

### What is the formula for converting farenheit to celsius?

I dont remember what the formula for converting temperatures from
farenheit to celsius?

### And what is the syntax for ArcSinus?

And what is the syntax for ArcSinus?

### What is the shortcut for switching between worksheets?

I would like to find out what is the shortcut for switching between
worksheets in the same workbook

### When writing an IF statement what is the syntax for "Not Equal to.

what is the syntax for writing an If statement for NOT EQUAL TOO

### What is the formula for changing the same cell on different sheet.

i want to change the same cell on many sheets in one go can anyone give me
the formula for this

### What is the VBA for the Excel 2007 "Switch Window" command button?

In Excel 2007, on the View tab, in the Window section, is a Switch Windows
button.

I would like to replicate that feature via VBA. Ie, during a subprocedure
run, I would like it to display the open workbooks and allow the user to
click on one of the results to activate that workbook.

What is the VBA for the Excel 2007 "Switch Window" command button?

### What is the alternative for the Property UsedRange

What is the alternative for the Property UsedRange

Example in this :

PHP Code:
R = Sheets("Material").UsedRange.Rows.Count

### IF Statement: What is the command for the "a number" part?

I am trying to write an if statement that says:

=if(a=1&b=a number,c1/d1,"na")

What is the command for the "a number" part?

### What is the formulae to write a work timecard in Excel

I am a payroll student and want to write a work timeclock ( clocking in and
out card) what is the formulae I need i.e

In 06:30 Out 12:00 In 13:00 Out 17:00

### What's the formula for alpha code?

I need the formula for alpha code for example the woord First National Bank
code is FNB now what's the code or formula you put in to change that to that.

### What is the error # for no access to network drive ?

Hi all,

This is part of my loop code:

ActiveWorkbook.SaveAs StoreDir & "Store_" & ws.Name & endoffilename & ".xls"
On Error GoTo ErrHandler:
pg.Sheets("Phone_Guidelines").Copy Before:=Workbooks("Store_" & ws.Name & endoffilename & ".xls").Sheets(1)
x = x + 1
mylog(x) = StoreDir & "Store_" & ws.Name & endoffilename & ".xls"
ActiveWorkbook.Close True

The SaveAs StoreDir location is a network path pathblabla all my folders are located on the same server, and I wanted to write an error handling block to deal with the error number instead of displaying a number to the user which would confuse.

What is the error number for when the SaveAs operation fails due to the network drive being down ?

Also, is this the best way to write the error handling code ?

I guessed the error number, where can I look them up ?

ErrHandler:
If Err.Number = 1004 Then ' network drive is down, so msg user and Exit routine
MsgBox ("It appears that the Store Network Drive is down, existing script. Please wait for the network drive availability before executing this script.")
Exit Sub
End If

### What is the formula to get projected growth

I am trying to get the formula for projected growth
example
I have a 1 TB hard drive that currently has 500gb in use. The growth rate
is 10% per year. How much data will reside on the drive after 3 years and 5
years.

I looked at using the =fv formula but the answer did not come out correctly
=fv(10,3,,-500) results = 665,500.00 s/b 665.50
=fv(10,5,,-500) results = 80.525,500.00 s/ 805.255

I am not sure if I am using the right formula
Help is greatly appreciated

Bret Snipes

### What is the purpose of IF

Hi,

What is the purpose of IF for this formula
=IF(ABS((AL\$5-\$Q7)*\$AG7)>ABS(AJ7),0,(AJ7-((AL\$5-\$Q7)*\$AG7)))

What is the formula doing?

Thanks.

### Formula For Cell To Equal Tab Name

Hi all,
I know that I have seen it here before but can't find it in the search function. What is the formula for getting a specific cell to be equal to the tab name?
Thanks,
Mike