Two if formulas in one cell

[JRR007]

My current formula is: =IF(ISERROR(AVERAGE(D14,G14,J14,M14,P14)),"",AVERAGE(D14,G14,J14,M14,P14))
It works great and does exectly what I need, there is only one problem. It shows the actual result. What I need it to do is "cap-out" at 100%. I can not have it measuring at over 100%. So if the result is 235%, I need it to read 100%. If it is 99% or less, I need it to read 99% or less. I need this while still showing a blank if there is an error.

Please help!!! Thanks in advance!!!

[Moo the Dog]

How about this:

Please Login or Register  to view this content.

- Moo

[DiggingDeeper]

Tidiest solution is to use =MIN(100%, ..................... )

(where is the formula/code button???)

Found it sorry, because you want a blank for 0% perhaps like this ..

Please Login or Register  to view this content.

If your averages are not percentages then you will need to use MIN(1, .....)

[JRR007]

You get the prize. Thank you very much - works perfectly. Thank you to everyone else as well for your efforts.

[Moo the Dog]

You're welcome, JRR.

- - - - - - - - - -
If your question has been answered, please remember to mark the thread as [SOLVED] by clicking on 'Thread Tools' right above your original post, and select 'Mark thread as solved".

Also, if you want to thank anyone that has helped you with a solution, click on the star below their name in one of their posts. It's always appreciated.