View Single Post
  #3   Report Post  
PCLIVE
 
Posts: n/a
Default

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