Excel - IF/AND/THEN ?

[sargie]

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.

 

[Quiet1]

try the is-blank bit first on its own?

=IF(NOT(ISBLANK(A1)),A1,IF(X>Y....

 

[omniscient]

is there any way, without revealing more than you wish to share, you can provide a screenshot or XLS file as a sample? even if you used bogus criteria or something to mask the true process, i might have a better idea how i would proceed.

of course, someone else may see exactly what you are asking and have a quick solution for you.

take care -

omni

 

[sargie]

Thanks. Here's a screenshot. As you can see, its a fairly straightforward formula, however, I need an override in D4 so that if D1 is NOT blank, use it, otherwise continue with the Cap/Floor IF statement.

Thanks again. Much appreciated.

 

[omniscient]

i think Q1 nailed it for you, but here's a little spreadsheet with my understanding.

hth

take care -

omni

 

[sargie]

yes - both are good. thanks guys, much appreciated. I didnt realise Excel had BLANK functionality to be honest ! cheers, S.

 

[TSGannGalt]

IF/AND/THEN ???

not

IF/THEN/ELSE

 

[ElectricSavant]

man you guys are awesome...too fast for me.