Forum Discussion

CEOBlockchain's avatar
CEOBlockchain
Copper Contributor
Dec 27, 2018
Solved

How to use the Subtract with IF function ?

Hi everyone,   Actually, I need some help about How I can use subtract with IF function Or any other way ? For example: If A>0 , make (B - C).   How I can use it on Excel, Please :)
excel
Formulas and Functions
  • Haytham Amairah's avatar
    Haytham Amairah
    Dec 28, 2018

    Okay, I've updated the workbook with this formula in AV Balance cell.

    =IF(D6>0,0,10000)

     

    If you want to change the AV Balance, you can change it in the formula from 10000 to something else.

     

    I hope this helps you

    Regards

Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Dec 27, 2018

Hi,

 

Let me show you a simple example as follows.

 

=IF(A2>0,B2-C2,A2)

 

 

The above formula says:

IF cell A2 greater than 0, then subtract cell C2 from B2 and return the result.

Otherwise, return the value of cell A2 as it is.

 

Please check out this https://support.office.com/en-us/article/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2 to learn more about IF function.

 

Hope that helps

AIKKID's avatar
AIKKID
Copper Contributor
Oct 24, 2022

Haytham Amairah HI .. this worked for me excellently.  now i would like to repeat the formula down the cells.  how do i do that formula with rang of cells.  i tried a couple of things that seemed logical but it didn't work. 

Resources