Results 1 to 10 of 20

Thread: Showing Custom Value Based on the Condition of Dynamic Table

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #20
    Member
    Join Date
    May 2020
    Posts
    66
    Rep Power
    6
    ( I believe the Excel function IFS is only available since Office 2016 ).
    If you share your formula solution to anyone with an earlier version of Office, then it won’t work!!!!
    ( I use Excel 2002, 2003, 2007 and 2010 only )
    Thanks for this information!
    Since I need only two value, 0 or 1, in the range X74:X81, it can be simply achieved by using 'IF' formula also. So, in order to make this workbook compatible, I've replaced the IFS function with IF formula.

    Thank you!
    Last edited by Anshu; 09-23-2020 at 10:44 AM.

Similar Threads

  1. Replies: 8
    Last Post: 06-01-2020, 06:13 PM
  2. Replies: 2
    Last Post: 03-18-2014, 02:29 PM
  3. Replies: 3
    Last Post: 08-15-2013, 01:00 AM
  4. Custom Charts in Excel :: Comparison RAG Chart Showing Tolerance Limits
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 06-13-2013, 09:40 PM
  5. Formula Based On Condition
    By Aryan063007 in forum Excel Help
    Replies: 4
    Last Post: 10-09-2012, 10:37 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •