LinkBack URL
About LinkBacks
Hello,
This is the formula:
Why does it return #N/A instead of a FALSE value which is
Please Login or Register to view this content.?Please Login or Register to view this content.
P.S. CellD23
Hello,
This is the formula:
Why does it return #N/A instead of a FALSE value which isPlease Login or Register to view this content.?Please Login or Register to view this content.
P.S. CellD23
hi kao. that's because the VLOOKUP could not find USDNZD in quotes worksheet. why not:
=IF(COUNTIF(quotes!B3:C40,B8&RIGHT(C12,3)),B8&RIGHT(C12,3),RIGHT(C12,3)&B8)
so the first part is simply counting if there is a combination "USDNZD" inside quotes worksheet.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Hello, thank you for your help.Originally Posted by benishiryo
I thought it might be because of VLOOKUP, but there is formula IF, which says that it cannot fulfill the condition it yet should return the FALSE value.
But RIGHT(C12;3)&B8 evaluates to NZDUSD.... not FALSE.
If you do want NZDUSD, use this (E16):
=IF(ISERROR((B8&RIGHT(C12,3)=VLOOKUP(B8&RIGHT(C12,3),quotes!B3:C40,1,0))),RIGHT(C12,3)&B8,B8&RIGHT(C12,3))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
the IF formula has 3 arguments; logical_test, value_if_true, value_if_false. so typically, the logical_test portion has to turn out to be TRUE or FALSE. when a VLOOKUP is unable to find the result, it becomes an #N/A. an #N/A error or any other errors are neither TRUE nor FALSE. Hence, the result is also an error for your case
So, how to make the formula so if the VLOOKUP unable to find the value it would return FALSE value (in this case RIGHT(C12;3)&B8) ?
I thought that's how its gonna be. if it cannot find it will just return the false
Have you looked at Post 4?
I did!
And it works!
Looks like both solutions work:
- this one and yours. Which one should I use? whats the difference and which one suits better my needs?Please Login or Register to view this content.
Whatever you wish. Pick whatever you want.... We don't know what your "needs" are!!
Personally, I'd go for
=IF(COUNTIF(quotes!B3:C40,B8&RIGHT(C12,3)),B8&RIGHT(C12,3),RIGHT(C12,3)&B8)
as it's easier to follow. I just unpicked yours and corrected it.
Okay, I will try to complete what I want to do here and I will post you the outcome.
Grand job.
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
One more thing here.
I will try to explain this.
Please Take a look at the yellow cells:
Capture.JPG
we can see GBP/USD - USD is the SECOND CURRRENCY in this particular currency pair
So, I would like to make the following:
IF Deposit Currency in cell B8 is the SECOND CURRRENCY in C21, excel would perform one calculation (division)
IF Deposit Currency in cell B8 is the FIRST CURRENCY in C21, excel would perform other kind of calculation (multiplication)
How this should be done?
what formula I should use in D28 to get the value instead of #N/A ?
thanks!
What value? There is no entry USDUSD in quotes, column B. You really do need to explain things better!!
Fixed this already.
Moving on :D
How to type some text in the cell and then put a formula in the same cell?
Lets say I wanna do smth like "Total Calories per day should not exceed (Cell B8*D4)"
="Total calories blah blah "&B8*D4&" more blah blah blah"
This is a new Q, not a variant of the previous one. You need to start a new thread for unrelated queries.
What's wrong here?
Capture.JPG
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks