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?


Post your answer or comment

comments powered by Disqus
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 rounding a dollar amount to the nearest nickel?

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

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

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.

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

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

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

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

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

And what is the syntax for ArcSinus?

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

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

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

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?

Thanks in advance.

What is the alternative for the Property UsedRange

Example in this :

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



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?

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

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.

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

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

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.

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


No luck finding an answer? You could always try Google.