Automatically modify a cell value

[MABeatty]

I have two cells to calcualte a percentage
Calls Received and Calls Logged which is used to calcualte a %.
Ocasionally, for whatever reason, calls logged will be greated than
calls recieved yielding a > 100% value. Is there a way to when
entering the calls logged value to check the Calls Recieved value and
if > automatically change the Calls Logged Value to = Calls recieved?

 

[Bob Phillips]

=MIN(A2,B2)/MAX(A2,B2)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Dave Peterson]

You could use a helper cell in your calculations:

Say column A has the received call quantity
B has the logged call quantity
Then you could put this kind of formula in column C:

=if(b2>a2,a2,b2)
(Give it a header of Adjusted Log calls quantity.)

Or you could just ignore the difference in raw numbers and use a different
formula for the percentage:

=min(b2/a2,1)

But that might hose up your grand total percentage (if you have one).