Modify A formula
Is possible to modify thisso that the value the minimum value returned is 2 ?
=ROUNDUP(COUNTIF('Filtered Allocation'!$A$2:$A$10000;A3)/3;0) Thank you in advance. |
Modify A formula
one way:
=MAX(2,ROUNDUP(COUNTIF('Filtered Allocation'!$A$2:$A$10000;A3)/3;0)) In article , carl wrote: Is possible to modify thisso that the value the minimum value returned is 2 ? =ROUNDUP(COUNTIF('Filtered Allocation'!$A$2:$A$10000;A3)/3;0) Thank you in advance. |
All times are GMT +1. The time now is 05:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com