Home |
Search |
Today's Posts |
#1
|
|||
|
|||
i need to make a formula that adds up my hours after my 40 hours
for example i put my hours daily but i need to have a formula that tells me
how many hours over time do i have after my 40 so the table automatic tells me how much more money do i earned that week example that i had already done b7-40*30.00 enter it works but not until i make 40 hours please help me if you can thank you |
#2
|
|||
|
|||
i need to make a formula that adds up my hours after my 40 hours
Try changing your formula to
=IF(B740,B7-40*30,"") The cell will be blank until you work more than 40 hours. |
#3
|
|||
|
|||
i need to make a formula that adds up my hours after my 40 hours
Hi, Try: IF(B740,B7-40*30,"") HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=479312 |
#4
|
|||
|
|||
i need to make a formula that adds up my hours after my 40 hours
Ever heard of a calculator? -- excelking54 ------------------------------------------------------------------------ excelking54's Profile: http://www.excelforum.com/member.php...o&userid=28348 View this thread: http://www.excelforum.com/showthread...hreadid=479312 |
#5
|
|||
|
|||
i need to make a formula that adds up my hours after my 40 hou
This problem is what Excel does best! If we all just used calculators,
Microsoft would go broke! "excelking54" wrote: Ever heard of a calculator? -- excelking54 ------------------------------------------------------------------------ excelking54's Profile: http://www.excelforum.com/member.php...o&userid=28348 View this thread: http://www.excelforum.com/showthread...hreadid=479312 |
#6
|
|||
|
|||
i need to make a formula that adds up my hours after my 40 hours
or =IF(B740,(B7-40)*30,"") ? Dave O Wrote: Try changing your formula to =IF(B740,B7-40*30,"") The cell will be blank until you work more than 40 hours. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=479312 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
one formula to make a multiplication table work | Excel Worksheet Functions | |||
Make a formula that adds every 4th cell in a column indefinately? | Excel Worksheet Functions | |||
Formula Help "Let me know if I do not make sence". | Excel Discussion (Misc queries) | |||
how do i make a cell date sensitive to execute a formula or input. | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) |