Forum Discussion

Diane Dambrosio's avatar
Diane Dambrosio
Copper Contributor
Nov 19, 2017

IF Function

I'm having problems figuring out an "IF" formula, I'm wondering if anyone can help me out.  The question is as follows:  If the Repeat? value is "YES", calculate the amount paid by subtracting 5 from...
excel
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Nov 19, 2017

Hello Diane,

 

Try this:

 

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Nov 20, 2017

    Or the same

    =A2-(B2="Yes")*5
    • Rach31's avatar
      Rach31
      Copper Contributor
      Apr 26, 2021

      SergeiBaklan 

       

      I know it's been years, but your formula still holds 🙂

      What if I want multiple cells subtracted from one particular cell, so:

       

      =A1-(B1="yes")*5

      =A1-(B2="yes")*3

      =A1-(B3="yes")*8

       

      Is there a way to make this one formula?

       

      Thanks!

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

        Rach31 

        Perhaps you mean

        =A1-(B1="yes")*5 - (B2="yes")*3 - (B3="yes")*8

    • Haytham Amairah's avatar
      Haytham Amairah
      Silver Contributor
      Nov 20, 2017

      Sergei,

       

      It's a very smart algorithm!

      Thank you!

Resources