USING iF WITH LARGE FORMULA

[howard]

I have formulas in in Col O


If the data in say B3:M3 are negatives, the formula to use =large(B3:M3,12) . if positive values then use large(B3:M3,1)

The values in the row will either all be positive or will be negative

I have tried to use the formula below , but get #value !

=IF(SUM(B3:M3<0),LARGE(B3:M3,12),LARGE(B3:M3,10))

It would be appreciated if someone can kindly amend it

 

[footoo]

=if(sum(b3:m3)<0,large(b3:m3,12),large(b3:m3,10))

 

[Legacy 143009]

Why you dont check only B3?

 

[footoo]

Why you dont check only B3?

Good point.

 

[howard]

Thanks for your input