ExcelBanter - Round, but give at least a value of 1 Q

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Round, but give at least a value of 1 Q (https://www.excelbanter.com/excel-worksheet-functions/164532-round-but-give-least-value-1-q.html)

Sean

Round, but give at least a value of 1 Q

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

Gary''s Student

Round, but give at least a value of 1 Q

=MAX(1,ROUND(E6*O$3,0))
--
Gary''s Student - gsnu2007a

Sean

Round, but give at least a value of 1 Q

Thanks Gary

All times are GMT +1. The time now is 02:23 PM.