Forum Discussion

ToddMulder's avatar
ToddMulder
Copper Contributor
Nov 15, 2022
Solved

Formula Working for Only Part of a Column in a Table

I have a formula in a Table that works for rows 4-16, then I get a #VALUE! error.  I've looked at the input type and everything else I can think of but nothing works.   Has anyone else experienced ...
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Nov 15, 2022

    ToddMulder 

    Or

    =IF(OR([@Container]=$T$4, [@Container]=$T$7, [@Container]=$T$14),[@[Per Piece w/ Discount Plus Shipping]],[@[Per Flat w/ Discount Plus Shipping]])*VLOOKUP([@Container],ecost7[[Container]:[Ecost Factor]],2,FALSE)

Resources