Multiple IFs returning errors

**matthewread88** · 07-18-2012, 12:08 PM

Hello all,

I have a list of URLs with them all ending either .co.uk .com or .co and each has a different value associated with it. So I need a list next to it that returns the value based on whether it is .co.uk .com or .co

I came up with this:
=IF(FIND(RIGHT("uk",2),B7),"1.99",(IF(FIND(RIGHT("com",3),B7),"2.99",(IF(FIND(RIGHT("co",2),B7),"3.99",FALSE)))))

It works for the .co.uk URLs but then returns #VALUE! for the others.

Any suggestions?

Thanks in advance :-)

**Pepe Le Mokko** · 07-18-2012, 12:14 PM

Embed the all the FIND functions in the ISNUMBER function like

Please Login or Register  to view this content.

Also note that FIND is case sensitive there where SEARCH is not

**Pete_UK** · 07-18-2012, 12:19 PM

Try it like this:

=IF(RIGHT(B7,2)="uk",1.99,IF(RIGHT(B7,3)="com",2.99,IF(RIGHT(B7,2)="co",3.99,FALSE)))

Hope this helps.

Pete

**Cutter** · 07-18-2012, 12:24 PM

You're using the RIGHT() function incorrectly

If the value is in A2

=IF(RIGHT(A2,2)="uk",1.99,IF(RIGHT(A2,3)="com",2.99,IF(RIGHT(A2,2)="co",3.99,FALSE)))

Note that the quotes have been removed from the 1.99, 2.99 and 3.99.
Put them back in if you want text results instead of numeric

**matthewread88** · 07-18-2012, 12:25 PM

Thanks that worked! Cheers mate :-)

**Cutter** · 07-18-2012, 12:37 PM

@ matthewread88

Forgot to say, "Welcome to the forum".

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself.
Thanks.