Results 1 to 8 of 8

If function, multiple conditions

Threaded View

  1. 08-26-2021, 01:43 PM #1
    melbin
    melbin is offline
    Registered User
    Join Date
    10-15-2017
    Location
    Bangalore, India
    MS-Off Ver
    Ms office 10
    Posts
    35

    If function, multiple conditions

    Hi...

    Could you please help me to apply IF function with multiple conditions?

    If the value in column D is in between 1 and 2, need "40" in column E.
    If the value in column D is in between 2 and 5, need "80" in column E.
    If the value in column D is in between 5 and 10, need "80" in column E.

    I have attached the file and conditions are also described in it. Please help me to find a solution!!!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. IF function with multiple conditions
    By szuruburru in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-08-2020, 09:35 AM
  2. [SOLVED] if multiple conditions are met, perform sum function using index function
    By billrogers184 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-31-2018, 02:49 PM
  3. multiple conditions which function to use
    By bbis21 in forum Excel General
    Replies: 7
    Last Post: 11-20-2014, 09:42 PM
  4. [SOLVED] Multiple conditions in if function
    By GIS2013 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-17-2013, 07:53 AM
  5. Multiple conditions for if function
    By jiyan200 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-12-2012, 11:12 AM
  6. multiple conditions on an If function.
    By hedgefund in forum Excel General
    Replies: 1
    Last Post: 04-21-2010, 09:42 PM
  7. IF Function - Multiple Conditions
    By jdavidson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-11-2007, 12:10 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1