I want to know that how many formulas we can use at a time in excel and how we can enter the one of the matter into another excel sheet by using formulas
Customer care support service NUMBER +1^(833)[[272]]^^0777.......CALL THEM
I want to know that how many formulas we can use at a time in excel and how we can enter the one of the matter into another excel sheet by using formulas
You have no limit It depends on your logical thinking and he kind of problem that you want to resolve
Excel 2003 have more than 1 lakh formulas.
In Excel 2007, the only limitiation is set by your computers memory... http://www.free-training-tutorial.com/formulas.html
That depends on which version of Excel you are using.
Excel 2003 supports up to 65,335 formulas
Excel 2007 has no limit.
you can communicate between the worksheets which are contained by one workbook (one excel-file).
Communicating between files cannot be done with formula's.
SOURCE: excel formulas
type in "=" and then go to the cell in the 2nd sheet and click on the cell that contains the value you want carried to sheet 1. Then drag copy the forumula in sheet 1 to all the cells you want it to relate to. Now, if you place a value in e.g. A1 of sheet 2, then that same value will appear in A1 of sheet 1.
Good luck.
SOURCE: EXCEL FORMULA
on sheet2!a1 type =sheet1!a1 - anything you type on sheet1!a1 will appear on sheet2!a1
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.
456 views
Usually answered in minutes!
I WANT TO KNOW THE LIST OF FORMULAS THAT IS USED IN MS EXCEL
ExcelExcel has no limits. It depends on the memory capacity of your pc
it has no limit
×