Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
negative value
I have created a soreadsheet with a field called 'Less 15% Reserve'.
want it to calculate the 15% amount based only if a positive numbe appears in the cell used for calculation, not if that amount is negative amount. How do I create the formula that would leave the cel at a '0' if in fact the calculator cell is a negative number? Please help! Thanks & Happy New Year Jo Attachment filename: summary log.xls Download attachment: http://www.excelforum.com/attachment.php?postid=39479 -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
negative value
Joe,
Try this formula =(A10)*A1*15% -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "huhnjoe" wrote in message ... I have created a soreadsheet with a field called 'Less 15% Reserve'. I want it to calculate the 15% amount based only if a positive number appears in the cell used for calculation, not if that amount is a negative amount. How do I create the formula that would leave the cell at a '0' if in fact the calculator cell is a negative number? Please help! Thanks & Happy New Year Joe Attachment filename: summary log.xls Download attachment: http://www.excelforum.com/attachment.php?postid=394790 --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
negative value
=Max(0,A1*.15)
or =if(A10,A1*.15,0) -- Regards, Tom Ogilvy huhnjoe wrote in message ... I have created a soreadsheet with a field called 'Less 15% Reserve'. I want it to calculate the 15% amount based only if a positive number appears in the cell used for calculation, not if that amount is a negative amount. How do I create the formula that would leave the cell at a '0' if in fact the calculator cell is a negative number? Please help! Thanks & Happy New Year Joe Attachment filename: summary log.xls Download attachment: http://www.excelforum.com/attachment.php?postid=394790 --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
negative value
Joe
=IF(J7<=0,0,J7*0.15) Gord Dibben Excel MVP On Thu, 1 Jan 2004 12:04:05 -0600, huhnjoe wrote: I have created a soreadsheet with a field called 'Less 15% Reserve'. I want it to calculate the 15% amount based only if a positive number appears in the cell used for calculation, not if that amount is a negative amount. How do I create the formula that would leave the cell at a '0' if in fact the calculator cell is a negative number? Please help! Thanks & Happy New Year Joe Attachment filename: summary log.xls Download attachment: http://www.excelforum.com/attachment.php?postid=394790 --- Message posted from http://www.ExcelForum.com/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
negative value
Joe,
Simplest answer = A1*0.85 zero * 0.85 is still zero 100% - 15% is 85% HTH Henry "huhnjoe" wrote in message ... I have created a soreadsheet with a field called 'Less 15% Reserve'. I want it to calculate the 15% amount based only if a positive number appears in the cell used for calculation, not if that amount is a negative amount. How do I create the formula that would leave the cell at a '0' if in fact the calculator cell is a negative number? Please help! Thanks & Happy New Year Joe Attachment filename: summary log.xls Download attachment: http://www.excelforum.com/attachment.php?postid=394790 --- Message posted from http://www.ExcelForum.com/ |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
negative value
85% of -100 is -85
So while it may be simple, it isn't the solution asked for I don't believe. How do I create the formula that would leave the cell at a '0' if in fact the calculator cell is a negative number? -- Regards, Tom Ogilvy Henry wrote in message ... Joe, Simplest answer = A1*0.85 zero * 0.85 is still zero 100% - 15% is 85% HTH Henry "huhnjoe" wrote in message ... I have created a soreadsheet with a field called 'Less 15% Reserve'. I want it to calculate the 15% amount based only if a positive number appears in the cell used for calculation, not if that amount is a negative amount. How do I create the formula that would leave the cell at a '0' if in fact the calculator cell is a negative number? Please help! Thanks & Happy New Year Joe Attachment filename: summary log.xls Download attachment: http://www.excelforum.com/attachment.php?postid=394790 --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing color of negative bar when using Invert if negative | Charts and Charting in Excel | |||
I want to get negative hours if subtraction of hours is negative | Excel Worksheet Functions | |||
Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions |