| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
max number then deduct in excel
TRY:
Assuming scores in columns A to G and SUM is in H: =IF(SUM(A1:G1)21,42-SUM(A1:G1),SUM(A1:G1)) HTH "Mike" wrote: Hi i got a worksheet that counts goals scored in a week and totals them in the last column using the "sum" function, but what i want it to do is not allow the total to go over 21, e.g if someone is on 20 goals and there team scores 3 then i want it to total to 21 then deduct whats left, in this case it would display a total of 19, one to make it 21 then two deducted, is this possible please -- thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formatting number value to text value in excel | Excel Worksheet Functions | |||
| Excel random number | Excel Discussion (Misc queries) | |||
| Excel 2003 random number generator | Excel Discussion (Misc queries) | |||
| how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
