Custom Search
Join the PC homebuilding revolution! Read the all-new, FREE 200-page online guide: How to Build Your Own PC!
NOTE: Using robot software to mass-download the site degrades the server and is prohibited. See here for more.
Find The PC Guide helpful? Please consider a donation to The PC Guide Tip Jar. Visa/MC/Paypal accepted.
Results 1 to 3 of 3

Thread: Excel & "if" statements

  1. #1
    Join Date
    Jan 2001
    Location
    England
    Posts
    339

    Question Excel & "if" statements

    Hi, I have used Excel for a while but a guy asked me the another day about
    "if" statements in Excel, can anybody shed light on this ? an example would
    be ideal.

    AW

    ------------------
    MB

    If we can't find the answer we keep on trying....never afraid to ask again.
    MarkBlack

    If we can't find the answer we keep on trying...I'm never afraid to ask again.

  2. #2
    Join Date
    Aug 2001
    Location
    Stanley NC
    Posts
    3,950

    Post

    any thing you want to know about Excel go here "IF" statements are about the 9th one down
    http://www.computersoftomorrow.com/excel.asp?menu=Excel

    ------------------
    Death has come to our windows.

    -- Jeremiah 9:21
    (undoubtedly a Biblical reference to a Microsoft product!)
    Want my weapons molon labe

  3. #3
    Join Date
    Oct 2001
    Location
    N of the S of Ireland
    Posts
    20,503

    Post

    A simple example to type into Cell C1
    =IF(A1=B1,"Same","Different")

    Then type different numbers into the cells A1 and B1
    If the numbers are the same C1 should show Same, etc...

    This works out because If(TestCondition, Result if True, Result if False)

    Or you can use the Function Wizard Button marked fx to help you design the conditions and what to calculate.

    ------------------
    Take nice care of yourselves - Paul
    Soup du jour: "I'm on two diets coz you don't get enough to eat on one." (anon)
    Take nice care of yourselves - Paul - ♪ -
    Help to start using BiNG. Some stuff about Boot CDs & Data Recovery Basics & Back-up using Knoppix.

Thread Information

Users Browsing this Thread

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
  •