Forum Discussion

Copper Contributor

Nov 13, 2022

excel formulas

Hello! I'm looking for a formula that will achieve the following: Currently, Cell A1 has the word "yes" Cell B1 has the word "no" I would like to the following to appear in C1. If cells A1 and ...

Formulas and Functions

mathetes

Silver Contributor

Nov 14, 2022

schrambo4430

You need to get acquainted with the IFS function,

=IFS(AND(A1="yes",B1="yes"),0,AND(A1="no",B1="no"),0,AND(A1="yes",B1="no"),100,AND(A1="no",B1="yes"),-100)

Or, if you want to get fancier with nested conditions

=IFS(OR(AND(A1="yes",B1="yes"),AND(A1="no",B1="no")),0,AND(A1="yes",B1="no"),100,AND(A1="no",B1="yes"),-100)

I'm quite sure there are other variations as well.

schrambo4430
Copper Contributor
Nov 14, 2022
I’ll be taking webinars on these fuctions, including IFS.
Thanks for reaching out and helping.
Schrambo4430