training in excel - Formula's

Resolved · Low Priority · Version Standard

Formula's

Waheena has attended:
Excel Introduction course
Excel Intermediate course

by - delegate Waheena [2 posts] (2007 Apr 3 Tue, 09:48) Reply

how do i find errors in my formula that is linked to other worksheets?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu	Bayswater	3	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	3	book now	£224	£224
2007	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 9 Tue	Tooting	0	FULL
2003	2008 Dec 11 Thu	Southwark	7	book now	£188	£215
2007	2008 Dec 16 Tue	Bayswater	6	book now	£207	£215
Full Schedule: See all 109 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: formula's

by - trainer Tracy platinum contributer [586 posts] (2007 Apr 4 Wed, 15:48) Reply

Hi Waheena,

Thank you for the question. I suggest you use the Formula Auditing facilities under the Tools menu to trace and correct your error. If you see the error is in a different workbook, use the same set of tools to find the error in the new workbook.

Good luck

Tracy

· Improve Performance Of Your Excel Macros
· Prepare for your MOS Certification with MS Excel Courses
· What's Better Than the Help Function in Excel? Microsoft Training
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Creating Charts with Excel

Excel tip:

Generating Random Numbers

To generate a random number in Excel use the = RAND() function.

The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)

Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.

Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive

View all Excel hints and tips

Rate this page: