Finding a percentage based on a condition

Question

I was wanting to know how to get a percentage of a cell based on if another cell has a text value of "yes". So for example if cell A1 = 100 and cell B1 = YES then I want to multiply A1*.25 and display it in B1. I've tried a few different thing such as&nbsp; =if(B1 "Yes", sum(A1*.25)) but that gives me an error. Any ideas.

detlef_lewin · Answer

DCP81&nbsp;MAX() is better than SUM().&nbsp;=(B1="Yes")*MAX(A1*0.25)&nbsp;&nbsp;

hansvogelaar · Answer

Detlef_Lewin&nbsp;
What is the point of using MAX with a single argument?
Why not
=(B1="Yes")*A1*0.25

dcp81 · Answer

It qorks, thanks for the help. 🙂

Forum Discussion

Finding a percentage based on a condition

3 Replies