Hi,
I thought the problem was solved in my post
http://www.vbaexpress.com/forum/showthread.php?t=36992
I'm attaching the workbook to see if this issue can be fixed.
If you look in column Ad, AE and AF you will see the formula that we are having an issue with. If you open this workbook and check the values in these columns and the open workbook in Excel2011 the data in the columns are different. The data in the "Windows" version is correct.( I had to do a replaceall for the "=" for it to calculate in Windows for some reason the Auto and F key did not do the cal)
They should for column AD have a value range of 3.00 to 5.00
Column AE value range 5.00 to 11.00 and for column AF about the same as AE.
Any help would be appreciated.