IF Function

[jfeyerer1]

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.

 

[FSt1]

hi
=if(A1>0,A1,0)

regards
FSt1

 

[Dave Peterson]

Another one:

=max(0,a1)

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