Help with formula

  • Thread starter Thread starter Ron King
  • Start date Start date
R

Ron King

Hi,
I need help with a formula. I need to get a percentage of catches to
total throws. I have 2 cells, one for misses and one for catches, the
formula I have right now works fine, it is =(Z4/(Z4+Y4))*10, were Z4 is the
catches and Y4 is the misses, I multiply by ten to get a whole number and
not a percent. Here is the problem, if Z4+Y4 (total throws) is less then
18, I need Z4 to be divided by 18. How do I do this, I'm guessing and
if/then statement, but I'm very new to Excel. Any help would be greatly
appreciated!

Thanks,
Ron
 
Hi Ron,

replace (Z4+Y4) with MAX(Z4+Y4,18)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Back
Top