# Excel True and False formula help

1. ## Excel True and False formula help

Hi I am new to the forum and new to excel in general.

I am trying to use this formula that I thought would make sense:

=IF(A1=TRUE,B1+44],[B1])

So if I put True in A1 then it would automatically add 44 to B1 and if False, It would just remain as the value in B1.

Also, I wanted to use "Yes" and "No" instead of "True" and "False" is there any way to do that?

Thanks you very much, any help is appreciated!

2. ## Re: Excel formula help

sphex,

Welcome to the Excel Forum.

Try:

=IF(A1="Yes",B1+44],[B1])

3. ## Re: Excel formula help

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

4. ## Re: Excel formula help

Hm it is telling me there is still an error in the formula for some reason

5. ## Re: Excel True and False formula help

I think Stan's formula has a typo, you don't need square brackest

=IF(A1="Yes",B1+44,B1)

6. ## Re: Excel True and False formula help

Or you can avoid IF function by; =B1+44*(A1="yes")

7. ## Re: Excel True and False formula help

^ Thank you that worked perfectly!,

I also have another problem:

I have 2 columns, one showing the total liability on different dates, and another column with either "yes" or "no" to a question.

I want to make a formula that will only add up the liabilities on the one column if it answers "yes", if "no" then it wont add.

8. ## Re: Excel True and False formula help

can anyone help me on this? much appreciated!

9. ## Re: Excel True and False formula help

Have a look at the SUMIF() function.

http://www.excelfunctions.net/ExcelSumif.html

10. ## Re: Excel True and False formula help

thanks cutter! that website gave some great information

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1