Skip to Content
0
Former Member
Jun 09, 2011 at 06:34 PM

Formula to yield a percentage

313 Views

Hi,

I have 2 formulas, TeamsSignedOutForAllRptGroups and TotalTeamsForAllRptGroups. These yield integer values of 751 and 798 respectively

I need to make a third formula, the % of teams signed out. This is simply

TeamsSignedOutForAllRptGroups / TeamsSignedOutForAllRptGroups

But this comes out as 1.

I have tried

CDBL(TeamsSignedOutForAllRptGroups / TeamsSignedOutForAllRptGroups )

and CDBL(CDBL(TeamsSignedOutForAllRptGroups) /CDBL( TeamsSignedOutForAllRptGroups ))

but it still comes out 1.

I want it to come out .9411 (which is 751/798).

What am I missing to make it do this?

Thanks,

Dick