Forum Discussion

JSzym's avatar
JSzym
Copper Contributor
5 years ago
Solved

Need help with an "IF" function for a yes/no answer

I'm trying to create an "IF" statement where...   If there is a "Y" in cell E44, then Excel should multiply the value in cell C44 by 1 (for 100% of that value). If there is a "N" in cell E44, then...
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    5 years ago

    JSzym 

    In F44:

     

    =IF(E44="Y",C44,0)

     

    Or, without IF:

     

    =(E44="Y")*C44

HansVogelaar's avatar
HansVogelaar
MVP
5 years ago

JSzym 

In F44:

 

=IF(E44="Y",C44,0)

 

Or, without IF:

 

=(E44="Y")*C44

  • JSzym's avatar
    JSzym
    Copper Contributor
    5 years ago
    Ah! Geez, I've been sitting here for 30 minutes cursing at this computer haha. Thank you, Hans! Still learning.

Resources