using the TEXT function

[richard oldcorn]

My problem is with the formula

="Maximum addition to interest rate which could occur i.e. "&TEXT((B9+B10),"0%")

If B9 = 4.5% and B10 =5%, how to I get the formula below to show

Maximum addition to interest rate which could occur i.e. 9.5%"), it keeps rounding up to 10 %.

Thanks and regards,

 

[SIXTH SENSE]

hi!
change this
TEXT((B9+B10),"0%")
to
TEXT((B9+B10),"0.00%")

 

[Ekim]

="Maximum addition to interest rate which could occur i.e. "&TEXT((B9+B10),"0.0%")

Last bit - format as "0.0%"

BTW, I suggest that you delete from your posts all information relating to your address and email address. Spammers and other types will love you.

Regards,

Mike