Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sean
 
Posts: n/a
Default why are the help files now remote?

ok im lokoing for the help files on Exel to do a =IF but there online WTF?!

oh anyway while im here i need exel to do this:
when a cell says 43 OR over i need it to remove the 40 and put the remaining
into a diff cell (works out ovetime rate) is this posable? i cant work it out
due to stupid help files being remote
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dana DeLouis
 
Posts: n/a
Default why are the help files now remote?

ok im lokoing for the help files on Exel to do a =IF but they're online...

Hi. If you don't like this feature, you can turn it off by doing the
following:

Tools | Options | General Tab | Service Options | 'Category' - OnLine
Content | and remove any checkmarks.

Hope this helps.
--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"Sean" wrote in message
...
ok im lokoing for the help files on Exel to do a =IF but there online
WTF?!

oh anyway while im here i need exel to do this:
when a cell says 43 OR over i need it to remove the 40 and put the
remaining
into a diff cell (works out ovetime rate) is this posable? i cant work it
out
due to stupid help files being remote



  #3   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default why are the help files now remote?

Hi!

A1 = 43

=MAX(0,A1-40)

Biff

"Sean" wrote in message
...
ok im lokoing for the help files on Exel to do a =IF but there online
WTF?!

oh anyway while im here i need exel to do this:
when a cell says 43 OR over i need it to remove the 40 and put the
remaining
into a diff cell (works out ovetime rate) is this posable? i cant work it
out
due to stupid help files being remote



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
Graphs in Other Files do not Update Dolphinv4 Excel Discussion (Misc queries) 0 October 21st 05 10:38 AM
Recently Used File List - 2002 Contains 'Temp' Files Keith972002 Excel Discussion (Misc queries) 0 July 26th 05 01:46 PM
merging my excel files Donna YaWanna Excel Discussion (Misc queries) 1 June 14th 05 12:53 AM
Cannot access read-only documents. tomgillane Excel Discussion (Misc queries) 14 February 7th 05 10:53 PM
importing multiple text files??? tashayu Excel Discussion (Misc queries) 0 December 19th 04 02:43 PM


All times are GMT +1. The time now is 05:39 AM.

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

About Us

"It's about Microsoft Excel"