if and large

[danz]

Hi All,

How do you do this one: if statement with large in a formula?

For example, if my first largest number does not meet my criteria then I want to extract my 2nd largest number and so on.

Hope you can help me with this one.


Many thanks and best regards,

 

[Marcelo Branco]

By the way, I still have trouble understanding in combining different functions.

When do you use double )) and triple ))) in a formula?


Thanks.

General rule
For each left (open) parenthesis you need a corresponding right (close) parenthesis

For example, in the formula below see the pairs in different colors

IF(SUM($D$2:D2) >=0.6*SUM($B$2:$B$300),"",LARGE($B$2:$B$300,ROWS($1:2)))

M.

 

[danz]

Well explained!

Your so great.

 

[scottylad2]

The arithmetic between the () will be done first without which can have serious effects on the result of a calculation

Excel Workbook
	F
21	20
22	36
Sheet1