+ Reply to Thread
Results 1 to 2 of 2

multiple if conditions

  1. #1
    Registered User
    Join Date
    02-04-2019
    Location
    Bucharest
    MS-Off Ver
    2017
    Posts
    1

    multiple if conditions

    Good day!
    i have a table with 4 columns.
    col1 col2 col3 col4
    Please help me with a formula that outputs the following:
    col1=empty & col2=empty & col3=empty & col4=empty => output a
    col1>0 & col2=empty & col3=empty & col4=empty => output b
    col1>0 & col2>0 & col3=empty & col4=empty => output c
    col1>0 & col2>0 & col3>0 & col4=empty => output d
    col1>0 & col2>0 & col3>0 & col4>0 => output e
    i've tried all the if/and and if/or formulas but i don't find the solution.
    Thanks in advance.
    Have a nice day!

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: multiple if conditions

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 29
    Last Post: 01-01-2017, 10:25 AM
  2. Replies: 2
    Last Post: 01-14-2016, 03:53 PM
  3. [SOLVED] Macro for data present in multiple rows and columns following multiple conditions
    By macrolearnerkk in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-07-2015, 11:20 AM
  4. [SOLVED] Vlookup - Country conditions (Multiple conditions)
    By dluhut in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-26-2013, 11:42 AM
  5. Insert multiple values from seperate table based on multiple conditions
    By drakesong in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-28-2011, 06:04 PM
  6. Replies: 1
    Last Post: 12-05-2010, 04:39 AM
  7. How to multiple conditions to validate more than 2 conditions to .
    By Bhuvana Govind in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-28-2005, 04:06 PM

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