Great minds think alike! Almost at least!On J1 use this:
=IF(SUM(B1,G1)>40,40,SUM(B1,G1))
On K1 use:
=IF(SUM(B1,G1)>40,SUM(B1,G1)-40,0)
There may be more efficient ways of doing this, but it gets the job done
Great minds think alike HahahaJ1: =if(sum(b1:g1)<40,sum(b1:g1),40)
K1: =if(sum(b1:g1)>40,sum(b1:g1)-40,0)
This will help you include the total up to 40 in J1 and any excess in K1. Hope that's what you're looking for.
GET OUT OF MY HEAD!!!!great minds think alike! Almost at least!
Does our two hour time difference count as a parallel universe??? I don't want to know any more details. You already have a copy of my bike. Getting scared!
thats kinda creepy huhDoes our two hour time difference count as a parallel universe??? I don't want to know any more details. You already have a copy of my bike. Getting scared!
Much appreciated guys.
You guys are very smart. :thumbup:
I went with:
column K
=SUM(B3:G3)-L3
column L
=IF(SUM(B3:G3)>40,SUM(B3:G3)-40,0)
Works great.
Nice to see the variations you guys came up with.
EDIT: Gave the two of you some REP for the help. (ajskillz and Rookie)