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

36 Replies

  • Deanpg7310's avatar
    Deanpg7310
    Copper Contributor
    Nov 22, 2023
    Hi Guys, I wonder if someone can assist me with my problem. If Column A subtract Column B gives you a negative figure, I would like Column C to indicate "Short" - If it is over, I would like Column C to indicate "Over". How do I write this formula to give me this result.
  • 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. 

    • Tops_dc's avatar
      Tops_dc
      Copper Contributor
      Apr 28, 2021
      Hi,
      Can you help me with this one.

      IF(A2<B2, A2-B2,A2) this one works but I want to add this next function
      IF(A2>=B2,"0"). The result says I already exceed 2 to 3 arguments.
      Can you help me?
      • MissBrissy's avatar
        MissBrissy
        Copper Contributor
        Jul 13, 2024

        Tops_dc  I am trying to do something along the lines of this but it does not seem to work for me.

        I want a cell F17 to update if there is an entry in F35. I want the current value in F17 to subtract by the value in F35 and display the new total.

         

        I tried to do a Conditional Format using the following, but it does not seem to work.

        IF(F35>0,F17-F35,F17)

         

        Is this even possible?

    • Abdul_Naveed192000's avatar
      Abdul_Naveed192000
      Copper Contributor
      Feb 06, 2021

      Haytham Amairah 

      Dear Sir,

       

                 Can I use multi-cell for calculation?

      For Example 

      if A2=1.1 and C2=3 and D2=A and If Sum of L2 TO T2 > 40-F2-H2 Then Sum of L2 To R2 and if Sum Of L2 TO R2 > 40-F2-H2 then answae L2 To P2 otherwise sum of L2 TO N2

      Also Sheet are Attached

      please help me

Resources