# "If(" to check for a cell with a number >0

Copper Contributor

# "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

3 Replies

# Re: "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

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.

# Re: "If(" to check for a cell with a number >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.

# Re: "If(" to check for a cell with a number >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)