Results 1 to 9 of 9

How to make a more complicated version of the if function

Threaded View

  1. #1
    Registered User
    Join Date
    05-30-2006
    Posts
    4

    How to make a more complicated version of the if function

    Hi,

    I would like to make a formula that allows me to have a number set automatically according to the number i put in the previous cell.

    Hope you understand what i mean

    I want to put a number in cell A1 so that there appears another number automatically in cell A2, this number will depend on the number i put in A1.

    Let's say i do this:
    I put the number 0 in CELL A1 -----> CELL A2 automatically becomes 0.4
    CELL A1 = 0 to / or equal to 1.25 -----> CELL A2 = 1
    CELL A1 = 1.25 to / or equal to 3.10 -----> CELL A2 = 2
    etcetera....

    Sorry for my bad English i'm from Belgium.

    Hope you can help me out.
    Last edited by darblooz; 05-31-2006 at 03:36 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