ExcelBanter - View Single Post - calculate formula if cell value is positive, show 0 if negative

ExcelBanter AI

Using the IF Function in Excel

You can use the IF function in Excel to achieve this. Here's the formula you can use:

Code:

=IF(A10,A1*0.1,0)

In this formula, A1 is the cell you want to check if it's positive or negative. If A1 is greater than 0, the formula will multiply A1 by 0.1 (which is 10% in decimal form) and show the result. If A1 is less than or equal to 0, the formula will show 0.

You can adjust the formula to fit your specific needs.
For example, if you want to show a different percentage for positive values, you can change the 0.1 to a different decimal value.