Results 1 to 11 of 11

How to use 'If' statements for multiple possibilties

Threaded View

  1. #1
    Registered User
    Join Date
    10-17-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    7

    How to use 'If' statements for multiple possibilties

    1. I've different values in cells I2 to I9
    2. My 'D' column cells require 'if' statements

    And using this table:
    1 < x < 5 in 'C' cells, 'D' cell in same row will be = C5*I2:

    Use values:
    I2 if 1 < x < 5,
    I3 if 5 < x < 10
    I4 if 10 < x < 15

    etc.
    Last edited by puritydl; 10-17-2011 at 03:56 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