You are reading a single comment by @mattty and its replies. Click here to read the full conversation.
  • RPM, the first formula looks ok structurally, but you are treating your numbers as strings (text), which might cause issues. Try this:

    [code]
    =IF(C2=1,G12,IF(C2=2,G14,IF(C2=3,G17,IF(C2= 4,G19,IF(C2=5,G22,IF(C2=6,G24,IF(C2="sm",G26, "")))))))
    [/code]

    Basically "2" is not the same as 2.

    EDIT: Tiswas got there before me.

About

Avatar for mattty @mattty started