2 sums one cell?
 

How do I get the final column to round down ?
May June July Total 3 month avg Daily Goal (Monthly goal divided by
20)
$50,810 $73,790 $93,131 $217,731 $72,577 $3,629 $3,600
$98,290 $106,416 $139,283 $343,989 $114,663 $5,733 $5,700
$41,789 $52,324 74,231 $168,344 $56,115 $2,806 $2,800
$37,163 $72,828 $41,998 $151,989 $50,663 $2,533 $2,500
$34,869 $58,453 $55,523 $148,845 $49,615 $2,481 $2,400

Current sum in that cell for daily goals is =SUM(O3)/20 giving number
of $3629
The next one is =FLOOR(P3,100) giving number of $3600

How do I get it all to happen in cell daily goals ?


--
phat al
------------------------------------------------------------------------
phat al's Profile: http://www.excelforum.com/member.php...o&userid=34988
View this thread: http://www.excelforum.com/showthread...hreadid=568801

2 sums one cell?
 

Hi!

Just put the math operation inside the FLOOR function:

=FLOOR(O3/20,100)

Biff

"phat al" wrote in
message ...

How do I get the final column to round down ?
May June July Total 3 month avg Daily Goal (Monthly goal divided by
20)
$50,810 $73,790 $93,131 $217,731 $72,577 $3,629 $3,600
$98,290 $106,416 $139,283 $343,989 $114,663 $5,733 $5,700
$41,789 $52,324 74,231 $168,344 $56,115 $2,806 $2,800
$37,163 $72,828 $41,998 $151,989 $50,663 $2,533 $2,500
$34,869 $58,453 $55,523 $148,845 $49,615 $2,481 $2,400

Current sum in that cell for daily goals is =SUM(O3)/20 giving number
of $3629
The next one is =FLOOR(P3,100) giving number of $3600

How do I get it all to happen in cell daily goals ?


--
phat al
------------------------------------------------------------------------
phat al's Profile:
http://www.excelforum.com/member.php...o&userid=34988
View this thread: http://www.excelforum.com/showthread...hreadid=568801

2 sums one cell?
 

thanks

so how many sums can i get in one floor sum?
you see i will want some totals under say 500 to turn red?
how would i do that and how easy is it to do?


--
phat al
------------------------------------------------------------------------
phat al's Profile: http://www.excelforum.com/member.php...o&userid=34988
View this thread: http://www.excelforum.com/showthread...hreadid=568801