Forum Discussion

jjgg73's avatar
jjgg73
Copper Contributor
Jul 22, 2020
Solved

if formulas in excel

morning 

 

i need a formula that will return a result in a cell based on a yes or a no. basically what i need is this

 

A1 has a dollar value A2 has either a Yes or a No A3 needs to be either 50% of A1 if A2 is yes or 100% of A1 if A2 is no

  • jjgg73 

     

    Think it could be 🙂
     
    Look please in the attached file
    A2 has a drop down menu to choose between yes or no.
    If satisfied please click the correct answer and click thumbs up ... if it is not what you are looking for please reply.
     

    Nikolino

    I know I don't know anything (Socrates)

     

2 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor

    jjgg73 

     

    Think it could be 🙂
     
    Look please in the attached file
    A2 has a drop down menu to choose between yes or no.
    If satisfied please click the correct answer and click thumbs up ... if it is not what you are looking for please reply.
     

    Nikolino

    I know I don't know anything (Socrates)

     

Resources