IF Formula currencies

Closed
blue - Feb 11, 2011 at 07:03 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 11, 2011 at 08:26 AM
Hello,

I am trying to use if formula for a table where i have 4 currencies and if one of the currencies matches the one that i have on top to divide the value with the rate...The formual i'm using is =IF(C6=C1:C4,B6/E1:E4,0). Please see table below:

1 A B C D E
2 EUR EUR/EUR 1.000000
3 USD USD/EUR 1.370150
4 GBP EUR/GBP 0.863141
5 NOK NOK/EUR 7.950432
6 TYPE JAN DOC CCY CCY JAN EUR INVOICE
7 EUR -

Can you please tell me what am i doing wrong? Thanks

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 11, 2011 at 08:26 AM
Hard to see in this format. If you could add a workbook with DATA and FORMULA

Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.


Note:
your data need not be to be real data but a good representative of how data looks like
0