Hi. I have a s/sheet which applies a margin above a swap rate. However, its based on multiple criteria of if the loan rate is above the Cap rate, use the Cap, and if its below the Floor, use the floor etc. However, I need to include another Cell, which if 'not blank' overrides any other value, ie the Swap rate and cap/floor. Any suggestions? I've tried various nested IF's/ AND's with no luck. Thanks.