Modify A formula


G

Guest

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.
 
Ad

Advertisements

J

JE McGimpsey

one way:

=MAX(2,ROUNDUP(COUNTIF('Filtered Allocation'!$A$2:$A$10000;A3)/3;0))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modify a Formula 4
Modify Formula 2
Modifying A Formula 12
Modify A Formula 5
Modify a Formula 1
Modify A Formula 2
Modify a Formula 2
Modify Formula 2

Top