software

I want to show in a cell the sum of another cell if 30 or more, if less than
30 zero.

Try something like this:

For a value in A1

B1: =IF(A1gt;=30,A1,0)
OR
B1: =(A1gt;=30)*A1

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXPquot;AlcanGaryquot; wrote:

gt; I want to show in a cell the sum of another cell if 30 or more, if less than
gt; 30 zero.

Assuming the values are in cells A1 and B1, and the result should be in cell
C1, then copy this formular

=IF(SUM(A3:B3) gt;=30,SUM(A3:B3),0)

into cell C1. This should solve the issue.

quot;AlcanGaryquot; wrote:

gt; I want to show in a cell the sum of another cell if 30 or more, if less than
gt; 30 zero.



quot;AlcanGaryquot; wrote:

gt; I want to show in a cell the sum of another cell if 30 or more, if less than
gt; 30 zero.
I don't think I was specific enough. I want the value of the cell over 30 ,
if the cell is less than 30 I want it to return zero.