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
Posted on Oct 28, 2016
Excel 2003 have more than 1 lakh formulas.
Posted on Nov 04, 2009
In Excel 2007, the only limitiation is set by your computers memory... http://www.free-training-tutorial.com/formulas.html
Posted on Jun 04, 2009
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.
Posted on Apr 04, 2008
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.
Posted on Sep 13, 2008
SOURCE: EXCEL FORMULA
on sheet2!a1 type =sheet1!a1 - anything you type on sheet1!a1 will appear on sheet2!a1
Posted on Nov 18, 2008
Jan 19, 2016 | Business & Productivity Software
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.
Aug 19, 2011 | Microsoft EXCEL 2004 for Mac
Mar 03, 2010 | Microsoft Excel for PC
Feb 04, 2009 | Microsoft Excel for PC
Dec 03, 2008 | Microsoft Office Professional 2007 Full...
Sep 20, 2008 | Microsoft Business & Productivity Software
Sep 13, 2008 | Microsoft Business & Productivity Software
Aug 08, 2008 | Microsoft Business & Productivity Software
Dec 19, 2007 | Microsoft Excel for PC
Jan 28, 2016 | Microsoft Excel for PC
375 people viewed this question
Usually answered in minutes!
I WANT TO KNOW THE LIST OF FORMULAS THAT IS USED IN MS EXCEL
×