I'd add a ROUND function to get rid of anything past the second decimal, and add a True False switch at the end to ensure that you don't apply an incorrect Fx amount to a date which doesn't exist in your table 1200 egp 500 kwd 26,042
Trying to create a spreadsheet that converts both directions - Pesos to dollars or dollars to pesos; my formulas are "at war" with one another 5600 egp 200 kwd 10,417

7120 egp 50 kwd 2,604.

25
البوابة الالكترونية الرسمية لدولة الكويت معلومات حول عملة دولة الكويت
Thanks- Fairly simple math issue
سعر الدينار الكويتي مقابل الجنية المصري اليوم الخميس 22
If you want to convert Sri Lankan Rupees into Australian Dollars, you would divide the number of rupees you have by
تحويل الدينار الكويتي (KWD) و الدولار الأمريكي (USD) : سعر صرف العملة التحويل حاسبة
Scenario is that we purchase materials in both MX and US for projects and will be entering both currencies into the sheet
6000 egp 2000 kwd 104,171 2800 egp 100 kwd 5,208
8560 egp 20 kwd 1,041 8000 egp 1000 kwd 52,085

Have you considered using, instead, a lookup table that would do this? Since that might end up with a number of decimal places, you might round it so that it ends up with just two.

تحويل العملات
2000 egp 10000 kwd 520,856
تحويل الدينار الكويتي (KWD) و الدولار الأمريكي (USD) : سعر صرف العملة التحويل حاسبة
سعر الدينار الكويتي مقابل الجنية المصري اليوم الخميس 22
In cell A3, I would put the formula to divide the Sri Lankan Rupees into Aussie dollars and round the results to the closest 2nd decimal