Forum Discussion

DCP81's avatar
DCP81
Copper Contributor
Aug 25, 2022

Finding a percentage based on a condition

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 displa...
excel
Formulas and Functions
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Aug 25, 2022

DCP81 

MAX() is better than SUM().

 

=(B1="Yes")*MAX(A1*0.25)

 

 

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Aug 25, 2022

    Detlef_Lewin 

    What is the point of using MAX with a single argument?

    Why not

    =(B1="Yes")*A1*0.25