I am trying to make a conditional for when I have prices in EUROS.
And I used this formula but it will only return the result as if it were always true.
When I evaluate the formula everything seems ok.
=IF(LEFT(NF,1)="€",Q12*P12/31*4.3916,Q12*P12/31)
Can anyone help me?
What is "NF" and shouldnt that be a cell reference?
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
No soultion to your problem but you could simplify that to
=Q12*P12/31*IF(LEFT(NF,1)="€",4.3916,1)
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hi and welcome to the forum
Presume that NF is a range name? what does it contain?
Perhaps provide a small sample workbook, showing what you have and what you want
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
What I want to acive is simple.
I want this excel to check a cell if it is formated for EURO currency and if so apply a formula.
I have about 700 items and not all come in EURO so I need a formula that does that.
NF is a name for =GET.CELL(53,Q12)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks