+ Reply to Thread
Results 1 to 2 of 2

Field calculation dependent on field values

  1. #1
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,285

    Field calculation dependent on field values

    Hi All
    I have only just worked out how to set up calculated fields in a table but this one is beyond me..

    I have 5 columns |T1|T2|T3|T4|GROUP|

    T1 = SHA/BAR
    T2 = FUE
    T3 = COM
    T4 = CAL

    If value in the field is > 0 Then GROUP should display the text equivalents of the Field headers and if more than one field > 0 Then GROUP should display MIX

    Any pointers appreciated

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    7,160

    Re: Field calculation dependent on field values

    how about
    =IF(COUNTA(A2:D2)>1,"MIX",INDEX(A$1:D$1,MATCH(MAX(A2:D2),A2:D2,0)))

    I suspect much better ways to do the header lookup - but that was my first idea

    see attached
    Attached Files Attached Files
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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: 2
    Last Post: 03-25-2022, 05:21 AM
  2. Replies: 1
    Last Post: 06-30-2019, 03:35 PM
  3. How to Make Cell Values Blank When Another Dependent Field is Duplicate
    By dts10 in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 03-13-2019, 01:36 PM
  4. [SOLVED] A pivot table field calculated using other field values as fields?
    By chrisf78 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 05-07-2015, 03:08 AM
  5. Change an existing field to a calculated field using Show Values as
    By Excel_vba in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-16-2012, 01:50 PM
  6. Replies: 0
    Last Post: 06-26-2012, 09:06 PM
  7. Replies: 9
    Last Post: 05-22-2012, 08:59 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1