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.