Results 1 to 3 of 3

=IF Function More than, Less than

Threaded View

  1. #1
    Registered User
    Join Date
    01-19-2010
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    8

    =IF Function More than, Less than

    Hi, i have a question which wants me to input a formula so that if the number is less than 2 in the cell "Day tripper" appears and if its more than 30 "too long" will appear.

    This is the formula i have got so far.

    =IF(I10="Less than 2","Day Tripper","Too Long")

    Where have i gone wrong, as nothing seems to work.
    Last edited by Haydn_17; 01-19-2010 at 07:34 AM.

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