mac excel 2011

  1. duvdevan

    Solved Excel Mac 2011 - Functions - IF statement

    I have 2 sheets on my workbook what I want to do is compare (Sheet2)C = (Sheet3)V and if the result is true then copy (Sheet2)D text into (Sheet3)W. =IF(V2=Sheet3!C2, Sheet3!D2, "") but the result I had is always FALSE or "" Columns C and V are numbers Sheet2 C...