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!
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!
=if(G8>5,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
Last edited by Ron Coderre; 06-01-2005 at 10:10 AM.
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(G8>5,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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
Do you want something in the cell if G8 is not greater than 5 hours? If not,
use this =if(G8>5,8,""). If you wanted to enter $4 if the cell was less
than 5 hours you would use =if(G8>5,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
>
>
what do you want if G* is <=5? 0? Nothing?
=IF(G8>5,8,0)
=IF(G8>5,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
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks