formula for sum 30 or more

[AlcanGary]

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

[Ron Coderre]

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.

[Tayo]

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.

[AlcanGary]

"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.