+ Reply to Thread
Results 1 to 10 of 10

Excel True and False formula help

  1. #1
    Registered User
    Join Date
    03-03-2011
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    5

    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!
    Last edited by sphex; 03-04-2011 at 01:57 PM.

  2. #2
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Excel formula help

    sphex,

    Welcome to the Excel Forum.

    Try:

    =IF(A1="Yes",B1+44],[B1])
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Excel formula help

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    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.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Registered User
    Join Date
    03-03-2011
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Excel formula help

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

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    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. #6
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Excel True and False formula help

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

  7. #7
    Registered User
    Join Date
    03-03-2011
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    5

    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.

    Thanks in advance!!

  8. #8
    Registered User
    Join Date
    03-03-2011
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Excel True and False formula help

    can anyone help me on this? much appreciated!

  9. #9
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Excel True and False formula help

    Have a look at the SUMIF() function.

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

  10. #10
    Registered User
    Join Date
    03-03-2011
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Excel True and False formula help

    thanks cutter! that website gave some great information

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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