If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel Help Needed!

orlamcnevin · 2008-04-30 12:52:50

Hi, I'm trying to figure out how to sum a row but also creating a rule where the result cannot exceed 37.5. ie: Mon Tues Wed Thurs Fri Basic Hours 7.5 7.5 10.5 7.5 7.5 37.5 (cannot exceed this figure) So you might be wondering why a sum us necessary at all... It may be the case that it would look like this... Mon Tues Wed…

30-04-2008 12:52pm

#1

orlamcnevin

Closed Accounts Posts: 29 ✭

Join Date: April 2008

Posts: 27

Hi,

I'm trying to figure out how to sum a row but also creating a rule where the result cannot exceed 37.5.

ie:

Mon Tues Wed Thurs Fri Basic Hours
7.5 7.5 10.5 7.5 7.5 37.5 (cannot exceed this figure)

So you might be wondering why a sum us necessary at all...

It may be the case that it would look like this...

Mon Tues Wed Thurs Fri Basic Hours
0 0 7.5 7.5 7.5 22.5

Hope all that makes sense!!

PS: I have a bet with someone in work about this so if I get the answer I'll win a bet!

PPS: Yeah so what if this is cheating!!

Failed to load the poll.

0