Overflow Problem

[jshinevar]

Hi all,
I am not a very experienced programmer, but this code keeps giving me a Runtime Error 6 Overflow, I'm not sure why. I understand what an error over flow is, but I do not understand why I am getting one. Any help would be appreciated... Thanks.

James

Please Login or Register  to view this content.

Sorry about not initially using the code tags,

[royUK]

Welcome to the forum, please read the Rules & use Code tags in future.

[wiggles]

Hi,
I think the problem is that both SeniorRate and NumberOfSenior is zero. Dividing 0/0 produces "overflow". You should test whether the NumberOfAny is non-zero (If ... Then ...).

w.

[royUK]

Can you attach a sample workbook?