Hi Max,

If I increase the size of COL K,L,M to 20 and A,B,C to 40, I'm not getting
'TRUE' in N1 at all..



"Max" wrote:

.. can Col K be automated as well?
Not sure. Fractionals vs integers issue.
Try posting in .programming

.. may I have a macro to Tap F9 to regenerate until N1 shows TRUE
Try posting in .programming
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---
"Kashyap" wrote in message
...
Thanks Max, everything seems to be working good.. But, I can insert ratio
in Col H (manually of with help of formula).

Also, may I have a macro to Tap F9 to regenerate until N1 shows TRUE..
Because all these will happen in the background. I have a different page
as
fromt end.

Thank you.