If Statement Question

  • Thread starter Thread starter Cheryl
  • Start date Start date
C

Cheryl

I am trying to create a timesheet.

I want to create a formula that does the following:

If Regular Time is greater than 7, place anything over 7
in this cell (G9).

I can do the =IF(G8>7, but now I am lost.

I am new. Can someone point me in the right direction?

Thanks

Cheryl
 
try

if(G8>7,G8-7,0)

This will placethe amount over 7 into G9 or plave a ) if the value is less
than 7, change the 0 to "" if you want the cell to be blank

Mark
 
Thanks so much!!

Really! You have no idea.
-----Original Message-----
try

if(G8>7,G8-7,0)

This will placethe amount over 7 into G9 or plave a ) if the value is less
than 7, change the 0 to "" if you want the cell to be blank

Mark





.
Click to expand...
 
Back
Top