Timesheet calculation problem

T

terrier

What I would like to do is calculate "if A1 is greater than 6 the
B1=A1-6 and A1=6" Can this be done and if so how? Any help would b
appreciated as am a complete novice with excel.

Thank
 

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

Help needed regarding calculating time 0
Merging cells and formats 8
Calculate After hours 3
VBA Coding Help for Beginner 0
Display weeks from a Milestone 0
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
Need help calculating probabilities 7
Drop Downs, Index Match or what? 56

Top