formula for sum 30 or more
 

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

formula for sum 30 or more
 

Try something like this:

For a value in A1

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

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

XL2002, WinXP


"AlcanGary" wrote:

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

formula for sum 30 or more
 

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) =30,SUM(A3:B3),0)

into cell C1. This should solve the issue.

"AlcanGary" wrote:

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

formula for sum 30 or more revised
 

"AlcanGary" wrote:

I want to show in a cell the sum of another cell if 30 or more, if less than
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.