# 20 Most Recent Microsoft Excel for PC - Page 6 Questions & Answers

You can but you will need software. Search for google for VBA password recovery tools. Search for the appropriate crack you have it all . .

Microsoft Excel... | Answered on Aug 05, 2013

I assume you are looking for the number of combinations of 1 - 45 where the first number is one of the 45, the second number is one of the remaining 44, etc. The answer is 45 factorial (i.e x=45*44*43*...*2*1). The Excel formula Is =FACT(45).

Microsoft Excel... | Answered on Jun 17, 2013

Select all sales entry one by one by pressing space bar, & after selecting all the entries. Siply press Alt+D. all the selected Entries Deleted at once.
Note:- This feature is available on in original Tally Users not for Crecked Tally.

Sachin Sharma
Axis Convergence Pvt Ltd
Noida

Microsoft Excel... | Answered on May 23, 2013

Hi,
for me to provide you with either screenshots or video or just text I need you to tell me your Excel version and Windows/Mac version.

Microsoft Excel... | Answered on Mar 25, 2013

Just go to the page layout in the toolbar & then from the sheet options press Sheet Right to Left bottom (highlighted with orange color as shown below).

Microsoft Excel... | Answered on Feb 15, 2013

To have the contents of the cell change from something you input into something else, you would need to put in a macro using VBA. You'll need someone who knows VBA to help with that.

OR... It is a lot easier to get similar results, if you are ok with using a few more cells to do it. The item# will remain where it was entered, and the product name will have to go in a different cell. In that case, you can use a lookup formula.

To do this, lets say your item# is entered in cell 'Sheet1'!C1, and you want the product_name to display in cell 'Sheet1'!D1. On another sheet (lets say sheet2) In cells 'Sheet2'!A1:B5 input the item#'s in the first column (column A1:A5) and input the matching product-names in column B1:B5. This is your lookup data. This sheet can be hidden if you want In cell 'Sheet1'!D1, use a vlookup formula that will look at the item# and find a match in the list, and display the product name for you. =vlookup('Sheet1'!C1,'Sheet2'!\$A\$1:\$B\$5,2,false)
This will display N/A# if the number can't be found.

Microsoft Excel... | Answered on Feb 15, 2013

You can click and drag them by the tabs and move them to their rightful
locations...

Microsoft Excel... | Answered on Jan 28, 2013

Microsoft Excel is a spreadsheet tool capable of performing calculations, analyzing data and integrating information from different programs. Microsoft Excel is comprised of organizational units called workbooks.

Microsoft Excel... | Answered on Jan 22, 2013

There isn't a function for this, but the formula should be something like this:
A1: Number to increase / decrease
B1: % change
C1: 'INC' or 'DEC'
D1: =IF(C1='INC', A1+(A1*B1), A1-(A1-B1))

Microsoft Excel... | Answered on Jan 01, 2013

Press F1 on your Ms Excel Window or write mode details here :D

Microsoft Excel... | Answered on Nov 16, 2012

Let say you have table like this
' A ' B
---'--------------'-----------
1 ' First ' 2
2 ' Second ' 1
3 ' Third ' 3
On Cell C1 or other cell you like, try to type this formula
=IF(B1<B2;IF(B2<B3;A1;IF(B1<B3;A1;A3));IF(B2<B3;A2;A3))

That's all, just IF and math operand

Microsoft Excel... | Answered on Nov 16, 2012

at first select the 1st page data and select data-subtotal from the upper menu list.
then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.

thanks

Microsoft Excel... | Answered on Nov 08, 2012

yes, you can do multiple criteria query but with a matrix formula. you may look it up. nonetheless, here is how one would look like:

{=sum(if(range1=A x range2=B x range3=C, sum range))} note that x (multiplication) is used to denote intersection of the criteria

initially, you'll enter it as:
=sum(if(range1=A x range2=B x range3=C, sum range))

then, edit the cell (F2) and press ctrl+shift+enter for the brackets { } to appear.

Microsoft Excel... | Answered on Nov 08, 2012

You could use the round function to split the value around the decimal point (assuming that is what you want to do).

e.g. in one cell the value is Rounddown(ref cell)
in other cell value is refcell - Rounddown(ref cell)

Might want to check help file on "rounding" to confirm exact function name

Microsoft Excel... | Answered on Nov 08, 2012

You can use an IF statement:

IF(logical_test,value_if_true,value_if_false)

In your case, this would be:

=IF(B6<>"",SUM((B6+D6)-(B5+C6)),"")

This works as follows:

IF(B6<>"", : If B6 is not equal to nothing, ie. it equals something

SUM((B6+D6)-(B5+C6)), : Set the value as per the equation

"") : Otherwise set the value to nothing.

Of course, this only checks that there is a value in B6. Depending on that value (and that of the other cells) you could still get a negative result. The way to avoid this would be to use the following:

=IF((SUM((B6+D6)-(B5+C6))>0),SUM((B6+D6)-(B5+C6)),"")

A bit long winded, but basically it checks the result of the sum is greater than 0. If it is it displays it, if not it leaves the cell blank.

Hope this helps,

Matt

Microsoft Excel... | Answered on Nov 08, 2012

Use the function =sum() to add numbers. To sum, for example, all of column A, enter in the formula bar =sum(\$A:\$A). You can use the subtotal function within the range you are adding and the answer will not count towards the final total.

Microsoft Excel... | Answered on Nov 08, 2012

#### Popular Tags

670 questions posted

Level 3 Expert

Level 3 Expert