Forum Discussion

P-Haywood1945's avatar
P-Haywood1945
Copper Contributor
Dec 22, 2023

"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
excel
mathetes's avatar
mathetes
Silver Contributor
Dec 22, 2023

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.

P-Haywood1945's avatar
P-Haywood1945
Copper Contributor
Dec 24, 2023

thanks for reaching out. 

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

  • mathetes's avatar
    mathetes
    Silver Contributor
    Dec 26, 2023

    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.

Resources