Forum Discussion
Need help with simple timesheet formula
Sorry, my skills with excel are limited, but I'm sure this will be a simple formula for most. Here's what I have and what I'm trying to achieve. Cells A-E all have a value of "10", representing ...
In cell F =IF(SUM(A1:E1)>40,40,SUM(A1:E1)) and in cell G =SUM(A1:E1)-F1 i guess this would solve your issue , if not please explain more in order for me to understand :)