Results 1 to 5 of 5

IF function problem

Threaded View

  1. #1
    Registered User
    Join Date
    06-01-2011
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Thumbs up IF function problem

    Hi to all,
    I would really appreciate any help i can get to solve my prob. I am trying to develop a formula using the IF function that will give me a number result rather than a word i.e. True / false etc.
    Here is the first part of my formula =IF(A1>10 what i want to say here is , then show the number that is in cell A1, the other half of the formula is if the number in A1 is less than 10, then show 0
    Last edited by bannister47; 06-01-2011 at 11:18 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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