Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Graphs in Other Files do not Update | Excel Discussion (Misc queries) | |||
Recently Used File List - 2002 Contains 'Temp' Files | Excel Discussion (Misc queries) | |||
merging my excel files | Excel Discussion (Misc queries) | |||
Cannot access read-only documents. | Excel Discussion (Misc queries) | |||
importing multiple text files??? | Excel Discussion (Misc queries) |