Forum Discussion
"If(" to check for a cell with a number >0
I need to make a formula that checks for amounts over 0.0 and then multiply the amount going into the cell will be *0
thanks for reaching out.
I want to check a cell and if it is greater than 0. I want another cell multipled by 0.
You still haven't given a really complete description. So let me offer the following, which is based on a LOT of assumptions.
Assumptions:
A1 is the cell that we're checking
B1 is the cell with the value for C1 if A1 is not zero.
This formula is what you enter in cell C1
=IF(A1=0,0,B1)
If this isn't helpful, then help us help you by spelling your situation out far more completely.