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
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
That sentence is a bit tricky to interpret. For one thing, it sounds like you want to check what is in a given cell, and IF it's greater than zero, THEN multiply it by zero. There is no formula, in any event, that will check what's in cell X and then change what is in cell X. That would involve circular reasoning, if it were possible.
But maybe that's not what you're saying. So please clarify.