Home |
Search |
Today's Posts |
#1
|
|||
|
|||
need help with formula...
Can someone help? This is a fairly simple question but beyond my knowledge I need to write a formula that looks at the total hrs in cell G8. If this total is greater than 5 hrs, the value of cell M is $8.00 Thanks for your help! :) -- rvnwdr ------------------------------------------------------------------------ rvnwdr's Profile: http://www.excelforum.com/member.php...o&userid=23903 View this thread: http://www.excelforum.com/showthread...hreadid=375621 |
#2
|
|||
|
|||
=if(G85,8,g8) If you want to see a different value if G8 is less than or equal to 5, just change the second G8 reference. Does that help? Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=375621 |
#3
|
|||
|
|||
You may need to elaborate on what format you are displaying hours in G8. If
it is just whole numbers, then you could use something like: =IF(G85,8,FALSE) Format cell M to currency. You also need to set what the amount will be if G8 is not greater than 5. To do that, replace FALSE in the formula above, with the number you want. HTH, Paul "rvnwdr" wrote in message ... Can someone help? This is a fairly simple question but beyond my knowledge I need to write a formula that looks at the total hrs in cell G8. If this total is greater than 5 hrs, the value of cell M is $8.00 Thanks for your help! :) -- rvnwdr ------------------------------------------------------------------------ rvnwdr's Profile: http://www.excelforum.com/member.php...o&userid=23903 View this thread: http://www.excelforum.com/showthread...hreadid=375621 |
#4
|
|||
|
|||
Do you want something in the cell if G8 is not greater than 5 hours? If not,
use this =if(G85,8,""). If you wanted to enter $4 if the cell was less than 5 hours you would use =if(G85,8,4) "rvnwdr" wrote: Can someone help? This is a fairly simple question but beyond my knowledge I need to write a formula that looks at the total hrs in cell G8. If this total is greater than 5 hrs, the value of cell M is $8.00 Thanks for your help! :) -- rvnwdr ------------------------------------------------------------------------ rvnwdr's Profile: http://www.excelforum.com/member.php...o&userid=23903 View this thread: http://www.excelforum.com/showthread...hreadid=375621 |
#5
|
|||
|
|||
what do you want if G* is <=5? 0? Nothing?
=IF(G85,8,0) =IF(G85,8,"") "rvnwdr" wrote: Can someone help? This is a fairly simple question but beyond my knowledge I need to write a formula that looks at the total hrs in cell G8. If this total is greater than 5 hrs, the value of cell M is $8.00 Thanks for your help! :) -- rvnwdr ------------------------------------------------------------------------ rvnwdr's Profile: http://www.excelforum.com/member.php...o&userid=23903 View this thread: http://www.excelforum.com/showthread...hreadid=375621 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |