| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Round, but give at least a value of 1 Q
=MAX(1,ROUND(E6*O$3,0))
-- Gary''s Student - gsnu2007a |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Round, but give at least a value of 1 Q
Thanks Gary
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Give RELEVANT responses to questions. DO NOT give usless list | Excel Worksheet Functions | |||
| I would like to give a key an other task, is it possible? THANKS | Excel Discussion (Misc queries) | |||
| look between 2 cells and give the value of only 1 | Excel Discussion (Misc queries) | |||
| How do I give a name to my group? | Excel Worksheet Functions | |||
| How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
Linear Mode
