Question about Microsoft Office Standard for PC
You can use this formula
=IF(A2<=100,"Within budget","Over budget")
If the number above is less than or equal to 100, then the formula displays "Within budget". Otherwise, the function displays "Over budget" (Within budget)
or you and try something like this
If the number above is 100, then the range B5:B15 is calculated. Otherwise, empty text ("") is returned ()
I got these examples from the help within Exel they give several more examples and more expaination.
Posted on Jan 10, 2009
SOURCE: getting the excel formula
Suppose the value for $ is stored in cell A3. Your formula would look like this: =(A3+A3*0.25)*1.5
The equals sign at the beginning of the formula is necessary. And if you want the result to be formatted as currency, you can do so by right-clicking the cell or column, format cell, number tab, choose currency.
Posted on Nov 15, 2007
SOURCE: average handle time
I have created a spreadsheet for you to a) use and b) to learn from.
It is an Automated spreadsheet (as they should be) which calculates the number of minutes in a working week or month and calculates the average time per email giving Daily, Weekly and Monthly Outputs. It takes into account Public Holidays (or for time off). You can use the Output to create Graphs etc to visually display the Output.
It also allows you to calculate a Part Month average.
I have displayed it as it was CONSTRUCTED and as it would be USED.
The As Used worksheet is Protected and the only Inputs that can be done are in the Green Boxes (also the Saturday and Sunday boxes but you will need to Unhide the Validation List to include these and then to add 2 more columns titled Is Saturday? and Is Sunday? with the appropriate If Statement.
To unprotect the sheet go to Tools - Protection - Unprotect. There is no password so leave this blank.
All the workings are still there, the columns are just Hidden. To Unhide them, highlight the columns to the left and right of the hidden columns, click on Format - Columns - Unhide. To hide them again, highlight the columns that you want hidden, click on Format - Columns - Hide.
The LOGIC used (as in Functions) may seem complex but if you read the Descriptions in the first row you should be able to work out what and why it was done that way. Click on a cell to see what Function was used where.
You said that your spreadsheet was becoming a real mess, well I have created a monster for you (but not a mess).
I have uploaded the file to here:
Hope this gives you the push to really start using Excel.
Posted on Apr 08, 2008
SOURCE: Excel formulas
yes it is.
"=Sheet1!A2+Sheet1!A1" <-this is the actually code in sheet2 column A1
ok let me explain
in A1 and A2 in sheet1 you got 50 and 50 like numbers.
in A1 on Sheet2 you have = sheet1 a1 + sheet1 a2.
did you get it?
dont know else how I should explain it...
Posted on Oct 09, 2008
SOURCE: VLOOKUP FORMULA PROBLEM
The assumption here is A1 in Sheet 1 is the cell you want to reference, This cell can be pasted - Any problems let me know.
Posted on May 22, 2009
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Oct 09, 2009 | Microsoft Excel for PC
Jul 29, 2009 | Computers & Internet
Feb 11, 2009 | Microsoft Excel for PC
Sep 13, 2008 | Microsoft Computers & Internet
Jul 08, 2008 | Microsoft Computers & Internet
145 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: