Negative Numbers
I'm putting togethet a spreadsheet for my employees bonuses. One of my
bonuses is a % of the profit made in our business. My current function is something like this =c3*.04, so if c3 is %1,000.00, then the cell brings $40.00, which is great. But, sometimes the profit is negative, such as, $(1,000.00). Which if you kept the same equation, would bring back, $(40.00), making my emloyees owe me $40.00. I can't seem to figure out how to make it so that if the profit is positive it will calculat the equation, but if it is negative, to just leave it alone, or atleast bring back $0.00 to the cell. Any help would be greatly appreciated. Thanks, |
Negative Numbers
Hi,
=MAX(0,C3*0.04) Mike "Griffindor107" wrote: I'm putting togethet a spreadsheet for my employees bonuses. One of my bonuses is a % of the profit made in our business. My current function is something like this =c3*.04, so if c3 is %1,000.00, then the cell brings $40.00, which is great. But, sometimes the profit is negative, such as, $(1,000.00). Which if you kept the same equation, would bring back, $(40.00), making my emloyees owe me $40.00. I can't seem to figure out how to make it so that if the profit is positive it will calculat the equation, but if it is negative, to just leave it alone, or atleast bring back $0.00 to the cell. Any help would be greatly appreciated. Thanks, |
Negative Numbers
=MAX(0,(C3*0.04)) to return a 0
Or =IF(C3*0.04<0,"",C3*0.04) to leave it blank Gord Dibben MS Excel MVP On Wed, 11 Feb 2009 12:17:01 -0800, Griffindor107 wrote: I'm putting togethet a spreadsheet for my employees bonuses. One of my bonuses is a % of the profit made in our business. My current function is something like this =c3*.04, so if c3 is %1,000.00, then the cell brings $40.00, which is great. But, sometimes the profit is negative, such as, $(1,000.00). Which if you kept the same equation, would bring back, $(40.00), making my emloyees owe me $40.00. I can't seem to figure out how to make it so that if the profit is positive it will calculat the equation, but if it is negative, to just leave it alone, or atleast bring back $0.00 to the cell. Any help would be greatly appreciated. Thanks, |
All times are GMT +1. The time now is 10:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com