IF SUM IS BELOW 5000, OUT PUT SHOULD BE 10% OF 5000, IF SUM IS ABOVE 5000 OUT PUT SHOULD BE 20% OF THE SUM.
If(sum($D$d:$D$16)<=5000,500,sum($D$5:$D$16)*.2)
Where the cells to be summed are D5 through D16.
SOURCE: Excel Formula
Use the round() function to specify how many decimal places you want to display. From the example you provided above, you could use the following formula:
=ROUND(SUM(A1:A4)*1.07,2)
The final "2" specifies that you want to display two digits to the right of the decimal point.
SOURCE: Excel Formula
Yes you can and there are two choices. The simple solution is to label a cell "divide by" and put your number in that filed. Then, by changing only that, your answer (in a separate cell) will be available.
There are more complex solutions -assuming your divide by number had some rhyme and reason that could be put in place but.....try this first and at a later date go back and play. Learning to do that will give you more than a fair amount of Excel expertise....something you may find fairly valuable as you continue on using Excel. FYI...I have developed full blown applications on Excel....it is an excellent tool. Hope this helps....Tango.
SOURCE: count , sum ect below scroll bar disappeared
Excel 2007 - This is called the status bar, right click on it if it is blank and put click to put a click next to the options you require.
Previous Versions - Click View --> Status Bar
SOURCE: FORMULA PROBLEM IN MS EXCEL
Are you trying to include the sum cell in your calculation - Check the formula bar.
Now just type your Numbers i.e. 571 for $571 and -650 for -$650 and sum using the normal way.Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.
Formulas used in Excel must follow a certain syntax.
Dear Madiha35,
I would recommend the use of the Table Function in Excel.
Here are the steps in Excel 2007, if this does not work for your version please add comment for me to reply to.
Conversely, If you would like the softcopy of the screenshots, I would be happy to email them to you.
Step 1: Enter your data into the worksheet.
Step 2: Create Table
Highlight the relevant data
On the insert tab, click on Table
Step 3: Verify Table range is correct, Click OK
Step 4: Select the cell you where you wish to Sum Data.
Click on Autosum.
Step 5: To Insert new data
Click on the sum row in the table, (Not the entire worksheet row)
Right click, Insert, Insert Table rows from above
Step 6: Enter new data in row
Step 7: Data is automatically calculated in formula.
85 views
Usually answered in minutes!
×