| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if less then zero put zero if greater then zero state number
I need a formula that goes like this
if 7000-c2-e2-g2 less then zero put zero in column & if 7000-c2-e2-g2 is greater then zero put the actual sum in column I need to have both in one column |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if less then zero put zero if greater then zero state number
=MAX(0,7000-c2-e2-g2)
"Pamela Jean" wrote: I need a formula that goes like this if 7000-c2-e2-g2 less then zero put zero in column & if 7000-c2-e2-g2 is greater then zero put the actual sum in column I need to have both in one column |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if less then zero put zero if greater then zero state number
=IF(700-(C2+E2+G2)<0,0,700-(C2+E2+G2))
"Pamela Jean" wrote: I need a formula that goes like this if 7000-c2-e2-g2 less then zero put zero in column & if 7000-c2-e2-g2 is greater then zero put the actual sum in column I need to have both in one column |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
| Way of making an object with a greater number be given a point.... | Excel Discussion (Misc queries) | |||
| calculate the number of words in a row whose length is greater than 2 | Excel Worksheet Functions | |||
| Display a greater number of recently used spreadsheets on File ta. | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
