Results 1 to 15 of 15

IFS Function Problem

Threaded View

  1. 03-24-2024, 01:21 PM #13
    DJunqueira
    DJunqueira is offline
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: IFS Function Problem

    Another proposition.

    Formula: copy to clipboard 
    =IF(MEDIAN(B20,$E$27,C20)<$E$27,D20,IF(MEDIAN(B20,$E$27,C20)=$E$27,$E$27-B20,0))
    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. [SOLVED] Problem with indirect function in XIRR function
    By lynnsong986 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 01-17-2020, 05:12 PM
  2. Function problem: Function correct but not running
    By helterskelter101 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-04-2018, 10:17 AM
  3. [SOLVED] problem with sum function
    By shivya in forum Excel General
    Replies: 11
    Last Post: 10-08-2017, 10:38 AM
  4. [VBA] Problem with outmail function - function sends mails only to 1 recepient
    By sauron12 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-21-2015, 03:30 PM
  5. Excel Problem with worksheet, need to know which function for penny a day doubled problem
    By excellhobo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-20-2013, 07:16 PM
  6. Problem Inserting Round function into an IF function
    By Ash87 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-11-2013, 05:37 PM
  7. Problem with MID Function
    By VICTOR5 in forum Excel General
    Replies: 5
    Last Post: 01-17-2011, 04:14 AM

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