Shortcut for multiple if statements

[geng]

I'm just wondering if there's a way for me to shorten this formula?

=IF(D6=$B$5+3,"Bucket 1",IF(A5="Bucket 1","Bucket 2",IF(B5="Bucket 1","",IF(C5="Bucket 3","",IF(A5="Bucket 2","Bucket 3",IF(B5="Bucket 2","",IF(C5="Bucket 2","",IF(A5="Bucket 3",0,""))))))))


Thanks!!!

[MarvinP]

Look at the Choose Function. If you can have "which bucket" calculate out to be a formula from 1 to 5 you could then have:

=Choose( Formula, "Bucket", "Bucket 2","Bucket 3","Bucket 4","Bucket 5")

[DonkeyOte]

I'm not sure CHOOSE is that applicable in this instance.

Could you outline the possible values for A5:C5 ?

Also, is it possible for A5:C5 to contain more than one value at any given time (ie A5:C5 could all read "Bucket 3" simultaneously)

The above will determine the order of precedence in the IF - as it stands should A5:C5 all hold "Bucket 3" the output of the existing formula would be Null rather than 0
(ie C5 takes precedence over A5 for this specific value)