Excel Formula

Closed

Beginner - Apr 10, 2010 at 03:26 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 10, 2010 at 06:04 PM

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?

Excel Formula
Date formula in excel dd/mm/yyyy - Guide
Number to words in excel formula - Guide
Excel grade formula - Guide
Logitech formula vibration feedback wheel driver - Download - Drivers
Transfer data from one excel worksheet to another automatically formula - Guide

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 10, 2010 at 06:04 PM

In C5 you can write

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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!