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.