Snasui Excel Forum

Hi Dear,

I have a bit hard related calculation rate per month to annum since the rate downloaded from a system mix with text not consistent so it is difficult to calculate.is there any formula to solve ?

Best Regards,

Could you please give me a condition line by line of your data?

Hi this is a new file with line by line narrative

How do you know cells A3, A5 and A6 are multiplied by 100 before multiply by 12?

Hi Dear
I Know it multiply by 100 since rate are at least 0.59% per month or 0.0059 .the rate not below this cap.

Best Regards,

Try this,

B2

=LEFT(A2,FIND("%",A2&"%")-1)*IF(A2<0.59,1200,IF(COUNT(SEARCH("ក្នុងមួយឆ្នាំ",A2)),1,12))

Enter > Copy down

Thank you