I want to show in a cell the sum of another cell if 30 or more, if less than 30 zero.
A AlcanGary May 16, 2006 #1 I want to show in a cell the sum of another cell if 30 or more, if less than 30 zero.
R Ron Coderre May 16, 2006 #2 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
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
T Tayo May 16, 2006 #3 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.
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.
A AlcanGary May 16, 2006 #4 AlcanGary said: I want to show in a cell the sum of another cell if 30 or more, if less than 30 zero. Click to expand... 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.
AlcanGary said: I want to show in a cell the sum of another cell if 30 or more, if less than 30 zero. Click to expand... 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.
