Excel dummy needing help with formula.

[OCCY1221]

Hi,
I am trying to write a simple formula for IF cell A3 says "YES" then the cell shows a result of (A1+A2)
and
IF the cell says "NO" then the cell shows a result of (A2-A1).
Im simple when it comes to excel so hoping this is an easy one for someone to help with here.
Thanks!

 

[kevin9999]

Hi,
I am trying to write a simple formula for IF cell A3 says "YES" then the cell shows a result of (A1+A2)
and
IF the cell says "NO" then the cell shows a result of (A2-A1).
Im simple when it comes to excel so hoping this is an easy one for someone to help with here.
Thanks!

Are "YES" and "NO" the only 2 possibilities?

 

[OCCY1221]

Are "YES" and "NO" the only 2 possibilities?

Correct.

 

[kevin9999]

Book1
	A
1	10
2	20
3	YES
4
5	30
Sheet1

Cell Formulas
Range	Formula
A5	A5	=IF(A3="YES",A1+A2,A2-A1)

Book1
	A
1	10
2	20
3	NO
4
5	10
Sheet2

Cell Formulas
Range	Formula
A5	A5	=IF(A3="YES",A1+A2,A2-A1)

 

[OCCY1221]

Thank you! I'll give it a shot.

 

[OCCY1221]

BRILLIANT! THANKS

 

[OCCY1221]

While I'm learning.. is there a way then to turn the YES result to a colour? Say Green and No to Red?

 

[kevin9999]

Conditional Formatting, something like this:

Book1
	A
1	10
2	20
3	YES
4
5	30
Sheet1

Cell Formulas
Range	Formula
A5	A5	=IF(A3="YES",A1+A2,A2-A1)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A3	Cell Value	contains "YES"	text	YES
A3	Cell Value	not containing "YES"	text	NO

Book1
	A
1	10
2	20
3	NO
4
5	10
Sheet2

Cell Formulas
Range	Formula
A5	A5	=IF(A3="YES",A1+A2,A2-A1)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A3	Cell Value	contains "YES"	text	YES
A3	Cell Value	not containing "YES"	text	NO

​

 

[OCCY1221]

Done! Thanks again!

 

[kevin9999]

Done! Thanks again!

You're welcome, and thanks for the feedback