| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
leave sum of j7 at 40 or less put excess in k7
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
leave sum of j7 at 40 or less put excess in k7
It would help if you used this white space to describe your problem in
more detail. Pete On Mar 17, 3:16*pm, payroll function <payroll wrote: |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
leave sum of j7 at 40 or less put excess in k7
If your sum is in h7, use:
J7: =min(40,h7) K7: =if(h740,h7-40,0) Regards, Fred "payroll function" <payroll wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Olap SSAS from excess | Excel Discussion (Misc queries) | |||
| Excess Columns | Excel Discussion (Misc queries) | |||
| Remove Excess | Excel Discussion (Misc queries) | |||
| would like help in Excess | Excel Worksheet Functions | |||
| Excess columns | New Users to Excel | |||
Linear Mode
