Why on earth I'm getting #Value! result?? Just cant figure anymore...
Basically, I'm looking to return values based on currencies selected.
IF B2 is USD and C2 is GBP, return currency conversion rate (D2) based on these pairs.
IF, however, B2 is GBP and C2 is EUR, then return currency conversion rate (D3) based on these pairs.
Lastly, IF B2 (GBP) is equal to C2 (GBP), then return 1.0000.
I've been using formula:
=IF(AND(B2="USD", C2="GBP"), D2, "-")
And it's been working fine.
So is:
=IF(B2=C2, "1.0000", "-")
But as soon as I blend them two together, I get #VALUE! error.
=IF(AND(B2="USD", C2="GBP"), D2, "-")+IF(B2=C2, "1.0000", "-")
I tried several variations, nothing works... what am I doing wrong?
Will have to add more currency pairs into this formula, but I think if I can get these two variations solved, should be okay to take it from there.
Thanking in advance for your help!
Bookmarks