Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting any negative number to zero
Thanks. here is my original formula:
=IF((J10-3000000)=2000001,30000,0.015*(J10-3000000)) "Mike Fogleman" wrote: =IF(A1-B1<0,0,A1-B1) If you had supplied your formula, I could have given the full answer. This would become part of your original formula. Mike F "kim" wrote in message ... I have an IF function and I want to add that if the end result ends up beign a negative number, it should be set it to zero rather than the negative number. But I don't know how to do that in conjunction with an already complete If statement. Any help is much appreciated. Thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting any negative number to zero
Try this...
=IF((J10-3000000)=2000001,30000,MAX(0,0.015*(J10-3000000))) -- Rick (MVP - Excel) "kim" wrote in message ... Thanks. here is my original formula: =IF((J10-3000000)=2000001,30000,0.015*(J10-3000000)) "Mike Fogleman" wrote: =IF(A1-B1<0,0,A1-B1) If you had supplied your formula, I could have given the full answer. This would become part of your original formula. Mike F "kim" wrote in message ... I have an IF function and I want to add that if the end result ends up beign a negative number, it should be set it to zero rather than the negative number. But I don't know how to do that in conjunction with an already complete If statement. Any help is much appreciated. Thank you |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting any negative number to zero
Hi. Perhaps another option...
= Max(0, Min(30000, 0.015*(J10 - 3000000)])) = = = HTH Dana DeLouis kim wrote: Thanks. here is my original formula: =IF((J10-3000000)=2000001,30000,0.015*(J10-3000000)) "Mike Fogleman" wrote: =IF(A1-B1<0,0,A1-B1) If you had supplied your formula, I could have given the full answer. This would become part of your original formula. Mike F "kim" wrote in message ... I have an IF function and I want to add that if the end result ends up beign a negative number, it should be set it to zero rather than the negative number. But I don't know how to do that in conjunction with an already complete If statement. Any help is much appreciated. Thank you |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting any negative number to zero
= Max(0, Min(30000, 0.015*(J10 - 3000000)]))
Oops! I forgot that this is my preferred technique... =MEDIAN(0,0.015*(J10-3000000), 30000) = = = HTH Dana DeLouis Dana DeLouis wrote: Hi. Perhaps another option... = Max(0, Min(30000, 0.015*(J10 - 3000000)])) = = = HTH Dana DeLouis kim wrote: Thanks. here is my original formula: =IF((J10-3000000)=2000001,30000,0.015*(J10-3000000)) "Mike Fogleman" wrote: =IF(A1-B1<0,0,A1-B1) If you had supplied your formula, I could have given the full answer. This would become part of your original formula. Mike F "kim" wrote in message ... I have an IF function and I want to add that if the end result ends up beign a negative number, it should be set it to zero rather than the negative number. But I don't know how to do that in conjunction with an already complete If statement. Any help is much appreciated. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change negative sign from end of number to the beginning of the number. | Excel Programming | |||
2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions | |||
Compare/match positve number against negative number? | Excel Programming | |||
Compare/match positve number against negative number? | Excel Programming | |||
Will setting Saved = True in Workbook_Open have a negative effect? | Excel Programming |