If Statement Question

[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

 

[Frank Kabel]

Hi
try
=IF(G8>7,G8-7,"")

 

[sh0t2bts]

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

 

[Geez]

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





.

 

[Cheryl]

Thank you too!

-----Original Message-----
Hi
try
=IF(G8>7,G8-7,"")

--
Regards
Frank Kabel
Frankfurt, Germany

.