Works 7.0 Format Question RRS feed

  • Question

  • I am trying to write a new spread sheet using Works 7.0 using the "IF" function but can not get the format correct. Let us assume that in cell A5 we have "CP" or "DV". I want to programme that if A5 = CP then cell A6=A1*A3 but if A5 is "DV" then cell A6=A2*A3. I see that the formula in A6 begins with IF(A5=CP but do not know the correct format from here. Please help.
    Thursday, April 27, 2017 4:32 AM