Jump to content
Please Use CODE Tags

Excel and Complex Large Functions

APrettyCoolWalrus
By APrettyCoolWalrus
in Programming
 Share
Go to solution Solved by APrettyCoolWalrus,

Use IF... OR:

=IF(OR(LARGE($F$6:$F$11,1),LARGE($F$6:$F$11,2)),D6+1,D6+0)

Thanks, I'm sure this would have worked but I found another function a few days ago.
Posted

Is making functions in excel even programming? Anyway...

 

I need to make these two functions into one function:

 

=IF(LARGE($F$6:$F$11,1),D6+1,D6+0)

 

=IF(LARGE($F$6:$F$11,2),D6+1,D6+0)

 

I have two objects, let's say dollar bills, that I have left over. I want to give one dollar to the person with the largest remainder (remainders are in the F column) and one dollar to the person with the second largest remainder. D6 is a rounded down number, the E column is where this complex function is going. More context is probably needed so ill provide it if its asked for.

 

Spoiler

i5 4670k, GTX 970, 12GB 1600, 120GB SSD, 240GB SDD, 1TB HDD, CM Storm Quickfire TK, G502, VG248QE, ATH M40x, Fractal R4

Spoiler

i5 4278U, Intel Iris Graphics, 8GB 1600, 128GB SSD, 2560x1600 IPS display, Mid-2014 Model

Spoiler

All the parts are here, just need to get customized cords to connect the motherboard to the front panel.

Link to comment
https://linustechtips.com/topic/524182-excel-and-complex-large-functions/
Share on other sites
Link to post
Share on other sites
Posted
  • Author

a comma?=IF(LARGE($F$6:$F$11,1),D6+1,D6+0), =IF(LARGE($F$6:$F$11,2),D6+1,D6+0) ?

that seems to give me answers of "TRUE" and "FALSE"

 

Spoiler

i5 4670k, GTX 970, 12GB 1600, 120GB SSD, 240GB SDD, 1TB HDD, CM Storm Quickfire TK, G502, VG248QE, ATH M40x, Fractal R4

Spoiler

i5 4278U, Intel Iris Graphics, 8GB 1600, 128GB SSD, 2560x1600 IPS display, Mid-2014 Model

Spoiler

All the parts are here, just need to get customized cords to connect the motherboard to the front panel.

Link to post
Share on other sites
  • 2 weeks later...
Posted
  • Author
  • Solution

Use IF... OR:

=IF(OR(LARGE($F$6:$F$11,1),LARGE($F$6:$F$11,2)),D6+1,D6+0)

Thanks, I'm sure this would have worked but I found another function a few days ago.

 

Spoiler

i5 4670k, GTX 970, 12GB 1600, 120GB SSD, 240GB SDD, 1TB HDD, CM Storm Quickfire TK, G502, VG248QE, ATH M40x, Fractal R4

Spoiler

i5 4278U, Intel Iris Graphics, 8GB 1600, 128GB SSD, 2560x1600 IPS display, Mid-2014 Model

Spoiler

All the parts are here, just need to get customized cords to connect the motherboard to the front panel.

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing Programming

×