Results 1 to 11 of 11

removing one... to the greater value...

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-10-2010
    Location
    Tavira, POrtugal
    MS-Off Ver
    Excel 2010
    Posts
    132

    removing one... to the greater value...

    I'm having with a big little problem.

    I am not able to compose a formula that will in the Annex.

    the problem is that when the columns are 0 def values in a, b and c, the formula always takes one. and what I am trying to do since yesterday is the following:

    if A, B or C are greater than the value of D, E or F, remove one.

    Well this is what is formulated to do actually, now that I do not want to go get formula values lower than E, for example. ie count only the highest value among D, E or F.

    I hope I have made to understand.

    Respects
    Attached Files Attached Files
    Last edited by Birnen; 09-02-2010 at 02:40 PM.

Thread Information

Users Browsing this Thread

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

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