• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

I put the whole function in one cell

GN0001

Member
Hello team,

This is my function; I put my function in a cell:
=IF(OR(LEFT(F2,3)=$V$2, LEFT(F2,3)=$V$3, LEFT(F2,3)=$V$4, LEFT(F2,33)=$V$5, LEFT(F2,3)=$V$6),"GG","ME")

It gives me error.

Unless I do Left function first and then on the next cell, I should use OR function on the result of Left function and then again on the next cell, I need to use If function on the result of OR function. What the problem is? I thinks: it says: #Value. All my values are number data type.

Regards,
GGGGGNNNNN
 
Hi,

Hard to guess without looking your file, can you please post a sample with expected output?

Blind shot:
=IF(OR(LEFT(F2,3)+0=$V$2, LEFT(F2,3)+0=$V$3, LEFT(F2,3)+0=$V$4, LEFT(F2,3)+0=$V$5, LEFT(F2,3)+0=$V$6),"GG","ME")

Regards,
 
Back
Top