Spreadsheet: 70056d1270719616-nested-if-statement-trouble-example-formula-problem-sample
Sheet: Base Rates

 | For "Loans" |  |  |  |  |  |  |  |  |  |  | For "Bonds"
 | Curr | GBP |  | Curr | EUR |  | Curr | USD |  |  |  | Curr | GBP |  | Curr | EUR |  | Curr | USD
 | Yrs | Libor |  | Yrs | Libor |  | Yrs | Libor |  |  |  | Yrs | Gov |  | Yrs | Gov |  | Yrs | Gov
 | 1 | 1.05 |  | 1 | 1.1035 |  | 1 | 0.557 |  |  |  | 1 | 0.663 |  | 1 | 0.629 |  | 1 | 0.4558
 | 1.125 | 1.1168625 |  | 1.125 | 1.1469375 |  | 1.125 | 0.63575 |  |  |  | 1.125 | 0.7266250000000001 |  | 1.125 | 0.6641250000000001 |  | 1.125 | 0.529825
 | 1.25 | 1.183725 |  | 1.25 | 1.190375 |  | 1.25 | 0.7145000000000001 |  |  |  | 1.25 | 0.79025 |  | 1.25 | 0.69925 |  | 1.25 | 0.60385
 | 1.375 | 1.2505875 |  | 1.375 | 1.2338125 |  | 1.375 | 0.7932500000000001 |  |  |  | 1.375 | 0.8538749999999999 |  | 1.375 | 0.734375 |  | 1.375 | 0.677875
 | 1.5 | 1.31745 |  | 1.5 | 1.27725 |  | 1.5 | 0.8720000000000001 |  |  |  | 1.5 | 0.9175 |  | 1.5 | 0.7695000000000001 |  | 1.5 | 0.7519
 | 1.625 | 1.3843125 |  | 1.625 | 1.3206875 |  | 1.625 | 0.9507500000000001 |  |  |  | 1.625 | 0.981125 |  | 1.625 | 0.804625 |  | 1.625 | 0.825925
 | 1.75 | 1.451175 |  | 1.75 | 1.364125 |  | 1.75 | 1.0295 |  |  |  | 1.75 | 1.04475 |  | 1.75 | 0.83975 |  | 1.75 | 0.89995
 | 1.875 | 1.5180375 |  | 1.875 | 1.4075625 |  | 1.875 | 1.10825 |  |  |  | 1.875 | 1.108375 |  | 1.875 | 0.8748750000000001 |  | 1.875 | 0.973975
 | 2 | 1.5849 |  | 2 | 1.451 |  | 2 | 1.187 |  |  |  | 2 | 1.172 |  | 2 | 0.91 |  | 2 | 1.048
 | 2.125 | 1.6529125 |  | 2.125 | 1.495 |  | 2.125 | 1.26775 |  |  |  | 2.125 | 1.2505 |  | 2.125 | 0.9561250000000001 |  | 2.125 | 1.1257
 | 2.25 | 1.720925 |  | 2.25 | 1.539 |  | 2.25 | 1.3485 |  |  |  | 2.25 | 1.329 |  | 2.25 | 1.00225 |  | 2.25 | 1.2034
 | 2.375 | 1.7889375 |  | 2.375 | 1.583 |  | 2.375 | 1.42925 |  |  |  | 2.375 | 1.4075 |  | 2.375 | 1.048375 |  | 2.375 | 1.2811
 | 2.5 | 1.85695 |  | 2.5 | 1.627 |  | 2.5 | 1.51 |  |  |  | 2.5 | 1.486 |  | 2.5 | 1.0945 |  | 2.5 | 1.3588
 | 2.625 | 1.9249625 |  | 2.625 | 1.671 |  | 2.625 | 1.59075 |  |  |  | 2.625 | 1.5645 |  | 2.625 | 1.140625 |  | 2.625 | 1.4365
 | 2.75 | 1.992975 |  | 2.75 | 1.715 |  | 2.75 | 1.6715 |  |  |  | 2.75 | 1.643 |  | 2.75 | 1.18675 |  | 2.75 | 1.5142
 | 2.875 | 2.0609875 |  | 2.875 | 1.759 |  | 2.875 | 1.75225 |  |  |  | 2.875 | 1.7215 |  | 2.875 | 1.232875 |  | 2.875 | 1.5919
 | 3 | 2.129 |  | 3 | 1.803 |  | 3 | 1.833 |  |  |  | 3 | 1.8 |  | 3 | 1.279 |  | 3 | 1.6696
 | 3.125 | 2.183875 |  | 3.125 | 1.8421875 |  | 3.125 | 1.8981875 |  |  |  | 3.125 | 1.86525 |  | 3.125 | 1.331875 |  | 3.125 | 1.72844375
 | 3.25 | 2.23875 |  | 3.25 | 1.881375 |  | 3.25 | 1.963375 |  |  |  | 3.25 | 1.9305 |  | 3.25 | 1.38475 |  | 3.25 | 1.7872875
 | 3.375 | 2.293625 |  | 3.375 | 1.9205625 |  | 3.375 | 2.0285625 |  |  |  | 3.375 | 1.99575 |  | 3.375 | 1.437625 |  | 3.375 | 1.84613125
 | 3.5 | 2.3485 |  | 3.5 | 1.95975 |  | 3.5 | 2.09375 |  |  |  | 3.5 | 2.061 |  | 3.5 | 1.4905 |  | 3.5 | 1.904975
 | 3.625 | 2.403375 |  | 3.625 | 1.9989375 |  | 3.625 | 2.1589375 |  |  |  | 3.625 | 2.12625 |  | 3.625 | 1.543375 |  | 3.625 | 1.96381875
 | 3.75 | 2.45825 |  | 3.75 | 2.038125 |  | 3.75 | 2.224125 |  |  |  | 3.75 | 2.1915 |  | 3.75 | 1.59625 |  | 3.75 | 2.0226625
 | 3.875 | 2.513125 |  | 3.875 | 2.0773125 |  | 3.875 | 2.2893125 |  |  |  | 3.875 | 2.25675 |  | 3.875 | 1.649125 |  | 3.875 | 2.08150625
 | 4 | 2.568 |  | 4 | 2.1165 |  | 4 | 2.3545 |  |  |  | 4 | 2.322 |  | 4 | 1.702 |  | 4 | 2.14035
 | 4.125 | 2.61075 |  | 4.125 | 2.1511875 |  | 4.125 | 2.4065625 |  |  |  | 4.125 | 2.379125 |  | 4.125 | 1.7525 |  | 4.125 | 2.19919375
 | 4.25 | 2.6535 |  | 4.25 | 2.185875 |  | 4.25 | 2.458625 |  |  |  | 4.25 | 2.43625 |  | 4.25 | 1.803 |  | 4.25 | 2.2580375
 | 4.375 | 2.69625 |  | 4.375 | 2.2205625 |  | 4.375 | 2.5106875 |  |  |  | 4.375 | 2.493375 |  | 4.375 | 1.8535 |  | 4.375 | 2.31688125
 | 4.5 | 2.739 |  | 4.5 | 2.25525 |  | 4.5 | 2.56275 |  |  |  | 4.5 | 2.5505 |  | 4.5 | 1.904 |  | 4.5 | 2.375725
 | 4.625 | 2.78175 |  | 4.625 | 2.2899375 |  | 4.625 | 2.6148125 |  |  |  | 4.625 | 2.607625 |  | 4.625 | 1.9545 |  | 4.625 | 2.43456875
 | 4.75 | 2.8245 |  | 4.75 | 2.324625 |  | 4.75 | 2.666875 |  |  |  | 4.75 | 2.66475 |  | 4.75 | 2.005 |  | 4.75 | 2.4934125
 | 4.875 | 2.86725 |  | 4.875 | 2.3593125 |  | 4.875 | 2.7189375 |  |  |  | 4.875 | 2.721875 |  | 4.875 | 2.0555 |  | 4.875 | 2.55225625
 | 5 | 2.91 |  | 5 | 2.394 |  | 5 | 2.771 |  |  |  | 5 | 2.779 |  | 5 | 2.106 |  | 5 | 2.6111
 | 5.125 | 2.9435 |  | 5.125 | 2.424375 |  | 5.125 | 2.81225 |  |  |  | 5.125 | 2.83975 |  | 5.125 | 2.135125 |  | 5.125 | 2.65560625
 | 5.25 | 2.977 |  | 5.25 | 2.45475 |  | 5.25 | 2.8535 |  |  |  | 5.25 | 2.9005 |  | 5.25 | 2.16425 |  | 5.25 | 2.7001125
 | 5.375 | 3.0105 |  | 5.375 | 2.485125 |  | 5.375 | 2.89475 |  |  |  | 5.375 | 2.96125 |  | 5.375 | 2.193375 |  | 5.375 | 2.74461875
 | 5.5 | 3.044 |  | 5.5 | 2.5155 |  | 5.5 | 2.936 |  |  |  | 5.5 | 3.022 |  | 5.5 | 2.2225 |  | 5.5 | 2.789125
 | 5.625 | 3.0775 |  | 5.625 | 2.545875 |  | 5.625 | 2.97725 |  |  |  | 5.625 | 3.08275 |  | 5.625 | 2.251625 |  | 5.625 | 2.83363125
 | 5.75 | 3.111 |  | 5.75 | 2.57625 |  | 5.75 | 3.0185 |  |  |  | 5.75 | 3.1435 |  | 5.75 | 2.28075 |  | 5.75 | 2.8781375
 | 5.875 | 3.1445 |  | 5.875 | 2.606625 |  | 5.875 | 3.05975 |  |  |  | 5.875 | 3.20425 |  | 5.875 | 2.309875 |  | 5.875 | 2.92264375
 | 6 | 3.178 |  | 6 | 2.637 |  | 6 | 3.101 |  |  |  | 6 | 3.265 |  | 6 | 2.339 |  | 6 | 2.96715
 | 6.125 | 3.20575 |  | 6.125 | 2.66275 |  | 6.125 | 3.1329375 |  |  |  | 6.125 | 3.29575 |  | 6.125 | 2.370125 |  | 6.125 | 3.01165625
 | 6.25 | 3.2335 |  | 6.25 | 2.6885 |  | 6.25 | 3.164875 |  |  |  | 6.25 | 3.3265 |  | 6.25 | 2.40125 |  | 6.25 | 3.0561625
 | 6.375 | 3.26125 |  | 6.375 | 2.71425 |  | 6.375 | 3.1968125 |  |  |  | 6.375 | 3.35725 |  | 6.375 | 2.432375 |  | 6.375 | 3.10066875
 | 6.5 | 3.289 |  | 6.5 | 2.74 |  | 6.5 | 3.22875 |  |  |  | 6.5 | 3.388 |  | 6.5 | 2.4635 |  | 6.5 | 3.145175
 | 6.625 | 3.31675 |  | 6.625 | 2.76575 |  | 6.625 | 3.2606875 |  |  |  | 6.625 | 3.41875 |  | 6.625 | 2.494625 |  | 6.625 | 3.18968125
 | 6.75 | 3.3445 |  | 6.75 | 2.7915 |  | 6.75 | 3.292625 |  |  |  | 6.75 | 3.4495 |  | 6.75 | 2.52575 |  | 6.75 | 3.2341875
 | 6.875 | 3.37225 |  | 6.875 | 2.81725 |  | 6.875 | 3.3245625 |  |  |  | 6.875 | 3.48025 |  | 6.875 | 2.556875 |  | 6.875 | 3.27869375
 | 7 | 3.4 |  | 7 | 2.843 |  | 7 | 3.3565 |  |  |  | 7 | 3.511 |  | 7 | 2.588 |  | 7 | 3.3232
 | 7.125 | 3.422375 |  | 7.125 | 2.864375 |  | 7.125 | 3.381125 |  |  |  | 7.125 | 3.53375 |  | 7.125 | 2.615125 |  | 7.125 | 3.334796875
 | 7.25 | 3.44475 |  | 7.25 | 2.88575 |  | 7.25 | 3.40575 |  |  |  | 7.25 | 3.5565 |  | 7.25 | 2.64225 |  | 7.25 | 3.34639375
 | 7.375 | 3.467125 |  | 7.375 | 2.907125 |  | 7.375 | 3.430375 |  |  |  | 7.375 | 3.57925 |  | 7.375 | 2.669375 |  | 7.375 | 3.357990625
 | 7.5 | 3.4895 |  | 7.5 | 2.9285 |  | 7.5 | 3.455 |  |  |  | 7.5 | 3.602 |  | 7.5 | 2.6965 |  | 7.5 | 3.3695875
 | 7.625 | 3.511875 |  | 7.625 | 2.949875 |  | 7.625 | 3.479625 |  |  |  | 7.625 | 3.62475 |  | 7.625 | 2.723625 |  | 7.625 | 3.381184375
 | 7.75 | 3.53425 |  | 7.75 | 2.97125 |  | 7.75 | 3.50425 |  |  |  | 7.75 | 3.6475 |  | 7.75 | 2.75075 |  | 7.75 | 3.39278125
 | 7.875 | 3.556625 |  | 7.875 | 2.992624999999999 |  | 7.875 | 3.528875 |  |  |  | 7.875 | 3.67025 |  | 7.875 | 2.777875 |  | 7.875 | 3.404378125
 | 8 | 3.579 |  | 8 | 3.014 |  | 8 | 3.5535 |  |  |  | 8 | 3.693 |  | 8 | 2.805 |  | 8 | 3.415975
 | 8.125 | 3.59725 |  | 8.125 | 3.031687499999999 |  | 8.125 | 3.5734625 |  |  |  | 8.125 | 3.713 |  | 8.125 | 2.827 |  | 8.125 | 3.46048125
 | 8.25 | 3.6155 |  | 8.25 | 3.049375 |  | 8.25 | 3.593425 |  |  |  | 8.25 | 3.733 |  | 8.25 | 2.849 |  | 8.25 | 3.5049875
 | 8.375 | 3.63375 |  | 8.375 | 3.0670625 |  | 8.375 | 3.6133875 |  |  |  | 8.375 | 3.753 |  | 8.375 | 2.871 |  | 8.375 | 3.54949375
 | 8.5 | 3.652 |  | 8.5 | 3.08475 |  | 8.5 | 3.63335 |  |  |  | 8.5 | 3.773 |  | 8.5 | 2.893 |  | 8.5 | 3.594
 | 8.625 | 3.67025 |  | 8.625 | 3.1024375 |  | 8.625 | 3.6533125 |  |  |  | 8.625 | 3.793 |  | 8.625 | 2.915 |  | 8.625 | 3.605596875
 | 8.75 | 3.6885 |  | 8.75 | 3.120125 |  | 8.75 | 3.673275 |  |  |  | 8.75 | 3.813 |  | 8.75 | 2.937 |  | 8.75 | 3.61719375
 | 8.875 | 3.70675 |  | 8.875 | 3.1378125 |  | 8.875 | 3.6932375 |  |  |  | 8.875 | 3.833 |  | 8.875 | 2.959 |  | 8.875 | 3.628790625
 | 9 | 3.725 |  | 9 | 3.1555 |  | 9 | 3.7132 |  |  |  | 9 | 3.853 |  | 9 | 2.981 |  | 9 | 3.6403875
 | 9.125 | 3.739975 |  | 9.125 | 3.1708125 |  | 9.125 | 3.7303 |  |  |  | 9.125 | 3.873 |  | 9.125 | 2.993875 |  | 9.125 | 3.6684390625
 | 9.25 | 3.75495 |  | 9.25 | 3.186125 |  | 9.25 | 3.7474 |  |  |  | 9.25 | 3.893 |  | 9.25 | 3.00675 |  | 9.25 | 3.696490625
 | 9.375 | 3.769925 |  | 9.375 | 3.2014375 |  | 9.375 | 3.7645 |  |  |  | 9.375 | 3.913 |  | 9.375 | 3.019625 |  | 9.375 | 3.7245421875
 | 9.5 | 3.7849 |  | 9.5 | 3.21675 |  | 9.5 | 3.7816 |  |  |  | 9.5 | 3.933 |  | 9.5 | 3.0325 |  | 9.5 | 3.75259375
 | 9.625 | 3.799875 |  | 9.625 | 3.2320625 |  | 9.625 | 3.7987 |  |  |  | 9.625 | 3.953 |  | 9.625 | 3.045375 |  | 9.625 | 3.7806453125
 | 9.75 | 3.81485 |  | 9.75 | 3.247375 |  | 9.75 | 3.8158 |  |  |  | 9.75 | 3.973 |  | 9.75 | 3.05825 |  | 9.75 | 3.808696875
 | 9.875 | 3.829825 |  | 9.875 | 3.2626875 |  | 9.875 | 3.8329 |  |  |  | 9.875 | 3.993 |  | 9.875 | 3.071125 |  | 9.875 | 3.8367484375
 | 10 | 3.8448 |  | 10 | 3.278 |  | 10 | 3.85 |  |  |  | 10 | 4.013 |  | 10 | 3.084 |  | 10 | 3.8648
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | **Caution: USD curve has more interpolation
 |  |  |  |  |  |  |  |  |  |  |  | GGR on Blbg for Generic Gov Rates