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

  • 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 link 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