Excel Formula

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello, I am a total beginner at Excel and I (really) need a formula...
If you could (please) give me the formula for this, I could alter it myself to fit what I need...

If the word "yes" is in B5, the value is 1.5 for B5.
If the word "no" is in B5, the value is 1.

What is the formula for that?

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
In C5 you can write

=IF(B5="yes", 1.5, 1)