Nested If functions and Formulas

G

Ginny

I am doing a time sheet and am having trouble doing IF functions and formulas
for cells.

=SUM((B6-B5)*24,(B4-B3)*24)
=IF(B7=0,"",SUM(B7-7.5))

What I'm trying to achieve is in B7 if B6=0, blank, if B6=7.5, blank,
otherwise B7=B6-7.5

In B7 I want to show overtime or deduct time if less than 7.5 hrs
How do I do this?

Thanks
 
J

JBeaucaire

Just me, but logically wouldn't you want B7 to be 0 for anything in B
from zero to 7.5? Overtime doesn't kick in until after 7.5, right

=IF(B6<=7.5,0,B6-7.5
 
G

Ginny

Not really because I also want it to show if you worked less than 7.5 how
much that would be - just don't want it to show anything if it's 0 or 7.5.
Does this help?
 
D

David Biddulph

Could you please explain to us what you want SUM(B7-7.5) to give you that
B7-7.5 won't do?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top