Forum Discussion
jjgg73
Jul 22, 2020Copper Contributor
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
- Think it could be 🙂Look please in the attached fileA2 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
- NikolinoDEPlatinum ContributorThink it could be 🙂Look please in the attached fileA2 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)
- jjgg73Copper Contributor