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

Copper Contributor

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

@P-Haywood1945 

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.

thanks for reaching out. 

I want to check a cell and if it is greater than 0. I want another cell multipled by 0. 

@P-Haywood1945 

 

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.