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 the Fee.  

I'm missing something in the formula that if the repeat value is "NO" it stays the same, not sure how to add that.  Can anyone help me out? 

 

Thanks,

Diane

 
excel

7 Replies

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

Resources