#s My Formula STDEV/AVERAGE TRUNC(STDEV)/AVERAGE

1449 NA
1422 NA
1231 8.63% 8.69% 8.63%
1521 8.80% 8.80% 8.75%
1362 7.73% 7.80% 7.73%
1450 7.04% 7.10% 7.04%


This is an example of what I am using. You can see there is a slight
difference between the three versions. The first column is the exact
same numbers that the company's software returns. It does appear that
the third formula is nearly identicle except for one number, and I
could use this. However, I still run into the issue of having to run
solver twice to get the correct answer. Is there anyway around this as
I am trying to use solver in a VBA macro? Thanks.


--
nakedbamboo
------------------------------------------------------------------------
nakedbamboo's Profile: http://www.excelforum.com/member.php...o&userid=28780
View this thread: http://www.excelforum.com/showthread...hreadid=484665