Edit for percentage in formula please :)

[Grammarjunkie]

Hey, guys. Thanks for stopping.
I was hoping someone could tell me what I need to do to fix this formula so that it pulls the VALUE portions in a 3 decimal format. Fields G9,D10, and J24 will all have percentages in them in three decimal places. When I'm CONCATENATE-ing, I'd like the value from those cells to be in 3 decimal places format, rather than what it's currently doing, which is 0.000XXX.

I'm not sure why I have a gap in knowledge on how to make this happen.
Thank you very much for any help.

=IF(J24="","",IF(G9="","",IF(D10="","",IF(AND(J24<>G9,G9=D10),CONCATENATE("Closing Disclosure Interest Rate (",VALUE(J24),") does not match Note or ELC Interest Rate (",VALUE(G9),")"),IF(AND(D10<>J24,J24=G9),CONCATENATE("ELC interest Rate (",VALUE(D10),") does not match Closing Disclosure or Note Interest Rate (",VALUE(G9),")",IF(AND(D10=J24,G9<>D10),CONCATENATE("Note Interest Rate (",VALUE(G9),") does not match Closing Disclosure or ELC Interest Rate (",VALUE(D10),")"),IF(AND(D10<>J24,D10<>G9,J24<>G9),CONCATENATE("Note Interest Rate (",VALUE(G9),"), ELC Interest Rate (",VALUE(D10),"), and Closing Disclosure Interest Rate (",VALUE(J24),")all do not match"),""))))))))

 

[Grammarjunkie]

if D and G don't match you get a false? Is that what you wanted

Nevermind. Haha. I was not missing a comma. Hmm. I'll have to stare at it until it comes to me.

 

[Grammarjunkie]

if D and G don't match you get a false? Is that what you wanted

Ah ha! I hadn't closed my CONCATENATE.

Thank you very much for your help!

 

[BGY23]

You're welcome. Glad it works