Top 20
Microsoft Excel for PC - Page 5 Questions & Answers
I want to use a
if A1 has the value as 2'-6".... your formule should be as below to obtain the desired reuslt...=(LEFT(A1,FIND("'",A1,1)-1))&(MID(A1,FIND("-",A1,1)+1,(FIND("""",A1,1)-(FIND("-",A1,1)+1))))
RUPEE INDIAN LOGO
Hihttp://posterous.com/getfile/files.posterous.com/foradian/3UAMU7WINSptf5AKZPu2v0PFx9AuWoAuUvDiKk2dvBK5nGectr2029CQ7EdP/Rupee_Foradian.ttfdown load the logo from above link and follow the instructionsThank you Harsha
My formulas is not working
Can you please explain what sort of formulas are failing? Please provide a couple of examples. Are there particular functions that don't work for you?
Rgds,
Scott
I need a formula length
Format cells A1 and B1 to dates.
A1 is the first date
B1 is the 2nd date
C1 enter the formula below
=DATEDIF(A1,B1,"y")&" years "&DATEDIF(A1,B1,"ym")&" months "&DATEDIF(A1,B1,"md")&" days"
What is excel
Hi,
Microsoft Excel is a commercial spreadsheet application . It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display.
Regards,
Shrey
Wen i am trying 2
Hi.If you have Microsoft office dvd or cd with keys.try to reinstall it. otherwise restore your PC back in time when your excel working properly.
Click Start>all programs>accessories>system tools>system restore.
I have made an excel
Possibly read only option is checked in file properties.
Right click the file and review the setting. Uncheck the read only box if necessary.
I want to write an Excel IF statement using only
Let say you have table like this ' A ' B---'--------------'-----------1 ' First ' 22 ' Second ' 13 ' Third ' 3On 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
My sum / count shortcut
Dear User,
You can simply right click on the status bar and select the desired options.
Regards,
Tech_Comp
How to format cell to
Hi,
You need to right click on the cell and click on:
Format Cells, Number Tab, Currency, Select Rs.
That will convert the cell to display INR.
If you require any further assistance, please comment and let me know, and I will be happy to assist you to further resolve your issue.
I will appreciate your feedback and positive rating for this solution.
Thank you.
On a shared workbook, I
Hi there fellow Microsoft user. I've encountered the same problem the first time I've worked for a networked environment. For all the changes to appear on the shared user here are the things you have to keep in mind:
1. You should have the administrator righst( The capability of making changes to the document e.g. delete, edit)
2. For the users to see the changes you've made, they need to close the file in question for them to see it. And of course their computers have to be online or sync within the network.
3. If the users have admin rights as well then they can definitely see the hidden columns and workbooks.
Hope this helps! Cheers
IN EXCEL HOW TO CUSTOMISE
Hi
Select Any single cell or group of cell, Right click --> Context menu will be displayed ----> Select Format Cells options --->in Format cell Windows Under Number Tab in the Category Section Select Currency and Under Symbol List Select Rs or INR as Indian Rupee Currency .and then Click okay Button
Regards
Ramsoft
I don't find the rupee
Please see the following site for step-by-step instructions.
http://www.caclubindia.com/forum/details.asp?mod_id=93297
How to use the new
Hi,
Please follow the below link for your problem.
http://www.tallysolutions.com/website/CHM/TallyERP9/04_ADVANCED_FEATURES_IN_TALLY/01_Advanced_Accounting_Features_in_Tally/Multi-Currency/Creating_a_Currency.htm
thanking you
davevipul197
When you select some data
I don't have 2010, but I do have 2007. Now, provided that status bar is still there, right click on it and check the boxes you want to show on your status bar, such as sum, count, etc.
If you status bar is not there, make sure your are in NORMAL view and not Full Screen View. Hit the escape key a few times to get back to Normal. It would also be a good idea to click on the View ribbon menu to see what view you are in.
After that, I am at a loss to assist you.
If I have a multi-row
Hi, I believe you're asking about 'freezing panes'...
In Microsoft Excel 2007:
- Select the place on the spreadsheet where you want the row titles to appear
- Click on the View tab
- Click on Freeze Panes button
- Select Freeze Panes
Or, you could be asking about defining print rows to appear at the top of each page:
- Select the Page Layout tab
- Click Print Titles
- Enter the Rows to Repeat at Top (e.g., 1:3 for the first 3 rows)
Hope that helps!
Not finding what you are looking for?