Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-25-2013, 10:56 AM
spaul spaul is offline How to create a formula using the IF in a time sheet. Windows 7 32bit How to create a formula using the IF in a time sheet. Office 2010 32bit
Novice
How to create a formula using the IF in a time sheet.
 
Join Date: Oct 2013
Posts: 1
spaul is on a distinguished road
Default How to create a formula using the IF in a time sheet.

Hello all I'm new to this forum and I need a little help on creating this formula. I need to add the IF as part of the formula here's what i would like to do after inputing the hours worked IF greater than 6 deduct .5, I created the formula which adds the hours, dollars and overtime.



any suggestions is appreciated.
Reply With Quote
  #2  
Old 10-25-2013, 11:28 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to create a formula using the IF in a time sheet. Windows 7 64bit How to create a formula using the IF in a time sheet. Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi
perhaps post a small sample sheet showing what you want to do?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 10-26-2013, 11:43 PM
Kevin@Radstock Kevin@Radstock is offline How to create a formula using the IF in a time sheet. Windows 7 32bit How to create a formula using the IF in a time sheet. Office 2010 32bit
Office 365
 
Join Date: Feb 2012
Posts: 94
Kevin@Radstock is on a distinguished road
Default

Perhaps something along these lines:

=IF(cell_ref>6,cell_ref-0.5,cell_ref)
Reply With Quote
  #4  
Old 10-28-2013, 07:19 PM
BobBridges's Avatar
BobBridges BobBridges is offline How to create a formula using the IF in a time sheet. Windows 7 64bit How to create a formula using the IF in a time sheet. Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Or a variation thereof:
Code:
=cell_ref-IF(cell_ref>6,0.5,0)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create a formula using the IF in a time sheet. Create a resource sheet in MS Project chabuk1 Project 8 05-01-2012 12:59 PM
How to create a formula using the IF in a time sheet. create tree list in excel sheet chuikingman Excel 5 06-27-2011 09:38 AM
How to create a formula using the IF in a time sheet. Sheet load time markg2 Excel 2 06-01-2011 06:00 PM
Please help me create this formula... doublejoy Excel 1 08-22-2009 03:04 AM
How to create a formula using the IF in a time sheet. Enter Number on any sheet one time only. paulrm906 Excel 1 04-28-2006 07:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:19 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft