Round, but give at least a value of 1 Q

[Sean]

How do I adjust the following formula to Round but give a value of at
least 1?

=ROUND(E6*O$3,0)

E6 = percentage of Sales
O3 = The total Bonus I have to distribute
But I wish to ensure that the formula produces at least a value of 1

Thanks

 

[Guest]

=MAX(1,ROUND(E6*O$3,0))

 

[Sean]

Thanks Gary