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

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?

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jul 14, 2024

      MissBrissy 

      That's with VBA programming if you consider such option, formula will return circular reference error.

      Even with VBA entire logic how to handle misprints is not clear. Let assume you have 200 in F17. In F35 10 is entered, F17 goes to 190.

      Now you found in F35 it shall be 100, not 10. Correcting F35 on 100 we have 90 in F17. Not 100 as it shall be.

      • MissBrissy's avatar
        MissBrissy
        Copper Contributor
        Jul 14, 2024

        SergeiBaklan 

        Ah, that makes perfect sense. I appreciate the response. I'm just starting to work with VBA and the greater functions of excel.

         

        Thank you for your assistance!

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 28, 2021

    Tops_dc 

    That is

    IF(A2<B2, A2-B2,0) 

or

=MAX(A2-B2,0)
    • Praveen1295's avatar
      Praveen1295
      Copper Contributor
      Jun 30, 2023

      =Max( )        this  function is very helpful thanks

Resources