Forum Discussion

Copper Contributor

Sep 02, 2021

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
Sep 02, 2021
JSzym

In F44:

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

Or, without IF:

=(E44="Y")*C44

HansVogelaar

MVP

Sep 02, 2021

JSzym

In F44:

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

Or, without IF:

=(E44="Y")*C44

JSzym
Copper Contributor
Sep 02, 2021
Ah! Geez, I've been sitting here for 30 minutes cursing at this computer haha. Thank you, Hans! Still learning.