| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Smaller than 0 to return a 0 result
Every tenant gets one free go per week. I need to create a formula where
where any negative numbers are returned as a '0' result. ('01'!C3+'02'!C3+'03'!C3+'04'!C3+'05'!C3+'06'!C3+' 07'!C3-1) Returns a -1 result. I need it to return '0' answer. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Smaller than 0 to return a 0 result
Well - first let's fix the formula. This assumes your sheets '01' through
'07' are ALL side by side Rewrite ('01'!C3+'02'!C3+'03'!C3+'04'!C3+'05'!C3+'06'!C3+' 07'!C3-1) as =SUM('01:07'!C3)-1 Now, to ensure it never goes negative, use =MAX(SUM('01:07'!C3)-1,0) "MWRhino" wrote: Every tenant gets one free go per week. I need to create a formula where where any negative numbers are returned as a '0' result. ('01'!C3+'02'!C3+'03'!C3+'04'!C3+'05'!C3+'06'!C3+' 07'!C3-1) Returns a -1 result. I need it to return '0' answer. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I look up a value and return more than one result? | Excel Worksheet Functions | |||
| excel result return wrong calcuation result | Excel Worksheet Functions | |||
| excel result return wrong calcuation result | Excel Worksheet Functions | |||
| excel result return wrong calcuation result | Excel Worksheet Functions | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
Linear Mode
