| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formula
want to add a1+b2, if that is less than zero, I want c2 to read 0, if it is
more than zero I want what 1a+b2 equals to show |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
excel formula
=IF(A1+B2<0,0,A1+B2)
-- Gary''s Student - gsnu200791 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
excel formula
=max(0,a1+b2)
or =if(a1+b2<0,0,a1+b2) AkitaMom wrote: want to add a1+b2, if that is less than zero, I want c2 to read 0, if it is more than zero I want what 1a+b2 equals to show -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
excel formula
Type the following in C2:
=IF((A1+B2)<0,0,A1+B2) "AkitaMom" wrote: want to add a1+b2, if that is less than zero, I want c2 to read 0, if it is more than zero I want what 1a+b2 equals to show |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
excel formula
Thank you :) I was putting in too many ( and not enough ,
Thanks for the help "Gary''s Student" wrote: =IF(A1+B2<0,0,A1+B2) -- Gary''s Student - gsnu200791 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| How do I view formula results intead of formula in excel? | Excel Worksheet Functions | |||
| i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) | |||
Linear Mode
