#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default excel time sheet

how can i write on mi time shhet for example "rest" wht out #VALUE!
error apears
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,574
Default excel time sheet

It's not clear from your post what your question is. Post the formula you're
using that returns the #VALUE! error.

Dave
--
Brevity is the soul of wit.


"aloncillo" wrote:

how can i write on mi time shhet for example "rest" wht out #VALUE!
error apears

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default excel time sheet

Don't use that cell for calculations.

Or use a formula that gives "rest" a value.

=IF(A1="rest", 10*A2,A1*A2)

If you posted a sample of your formula that you're using perhaps someone could
offer an alternative.


Gord Dibben MS Excel MVP

On Mon, 11 Dec 2006 06:42:00 -0800, aloncillo
wrote:

how can i write on mi time shhet for example "rest" wht out #VALUE!
error apears


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Time Sheet For Employees blindmanwalks Excel Discussion (Misc queries) 6 November 4th 06 04:53 AM
Asked previously...can this not be done in excel simonsmith Excel Discussion (Misc queries) 2 May 16th 06 11:50 PM
Excel Time Sheet - Rounding To Quarter Hours C A Excel Worksheet Functions 2 October 18th 05 07:21 PM
Does excel recognise names rather than cells? Sue Excel Worksheet Functions 9 May 22nd 05 04:51 AM
I need an Excel bi-weekly employee time sheet template Books Excel Discussion (Misc queries) 4 April 4th 05 12:43 AM


All times are GMT +1. The time now is 02:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"