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

Microsoft Excel... | Posted on Jul 23, 2013 | Be the first to answer

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

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

Put this in E1:

=IF(A1<>0,500,IF(C1=500,0,500))

=IF(A1<>0,500,IF(C1=500,0,500))

Microsoft Excel... | Answered on Apr 13, 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.

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.

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...

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))

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

' 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

Depends on which produc. Here are a couple links for Office 2007 and 2010.

http://office.microsoft.com/en-us/excel-help/download-office-2010-training-HA101901726.aspx

http://office.microsoft.com/en-us/training/download-office-2007-training-HA010192650.aspx

http://office.microsoft.com/en-us/excel-help/download-office-2010-training-HA101901726.aspx

http://office.microsoft.com/en-us/training/download-office-2007-training-HA010192650.aspx

Microsoft Excel... | Answered on Nov 09, 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

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

i'll just reply to your conditional sumif query.

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.

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

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

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

670 questions posted

Usually answered in minutes!

41 Questions

-5 Questions

11 Questions

2 Questions