IF Function
 

I want to insert a formula that puts in the value of a cell if it is
greater than 0 or the number 0 if not.
cell A1 = 25.00
cell B1 Result wanted: 25.00

cell A1 = -25.00
Cell B1 Result wanted: 0

Want to put a number in a cell only if it is within a range
cell A1= 45.00
Cell B1 = IFCell A1 =45 and <100, return value in A1 or 0
Result would be 45.00

Hope someone can help.

IF Function
 

hi
=if(A10,A1,0)

regards
FSt1

" wrote:

I want to insert a formula that puts in the value of a cell if it is
greater than 0 or the number 0 if not.
cell A1 = 25.00
cell B1 Result wanted: 25.00

cell A1 = -25.00
Cell B1 Result wanted: 0

Want to put a number in a cell only if it is within a range
cell A1= 45.00
Cell B1 = IFCell A1 =45 and <100, return value in A1 or 0
Result would be 45.00

Hope someone can help.

IF Function
 

Another one:

=max(0,a1)

and
=if(and(a1=45,a1<100),a1,0)



wrote:

I want to insert a formula that puts in the value of a cell if it is
greater than 0 or the number 0 if not.
cell A1 = 25.00
cell B1 Result wanted: 25.00

cell A1 = -25.00
Cell B1 Result wanted: 0

Want to put a number in a cell only if it is within a range
cell A1= 45.00
Cell B1 = IFCell A1 =45 and <100, return value in A1 or 0
Result would be 45.00

Hope someone can help.

--

Dave Peterson