Forum Discussion

OUTLOOK670's avatar
OUTLOOK670
Copper Contributor
Dec 04, 2019

Excel function not working

Hello, I have Windows 10 and I am trying to use this function in excel however it is not working. It is just giving me the error #NAME. Other team members are able to sue this function- would yo kno...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Dec 05, 2019

OUTLOOK670 

In addition to all above, if write such formulas when use at least some formatting

=IF(ItemName="",
   "",
   CONCATENATE(
      IF(OR(
            VendorMapRules="update",
            AND(PurchasePrice=0,MAP=0),
            AND(
               IFERROR(ShipCost=0,FALSE),
               ShipCostOverride="no override",
               MAP=0
            ),
            ISERROR(ShipCost),
            AND(
               Disc="yes",
               MapRequired="yes",
               VendorMapRules<>"NO MAP"
            ),
            ISERROR(FloorPriceAdjusted*1),
            AND(
               IFERROR(ProfitAtFloor+0.01<DesiredProfit,FALSE),
               ExcludedFloor="",
               FollowExcluded="Follow excluded",
               VendorMapRules<>"Set at base"
            ),
            VendorMapRules="",
            AND(
               DSItem=TRUE,
               DSFee=0,
               ifna(ItemFulfillmentCost=0,TRUE)
            )
         ),
         "Error:",0),
      IF(
         VendorMapRules="update",
         " Update vendor MAP rules",""
      ),
      IF(
         AND(PurchasePrice=0,MAP=0),
         " $0 purchase price",""
      ),
      IF(
         AND(IFERROR(ShipCost=0,FALSE),
            ShipCostOverride="no override",MAP=0
         ),
         " $0 ship cost",""
      ),
      IF(
         ISERROR(ShipCost),
         IF(
            SalesChannel="FBM",
            " Missing shipping data",
            "No FBA fulfillment fee"
         ),
         ""
      ),
      IF(
         AND(
            DSItem=TRUE,
            DSFee=0,
            ifna(ItemFulfillmentCost=0,TRUE)
         ),
         " No DS fee",
         ""
      ),
      IF(
         VendorMapRules="",
         " No vendor MAP rule",
         ""
      ),
      IF(
         AND(
            IFERROR(ProfitAtFloor+0.01<DesiredProfit,FALSE),
            ExcludedFloor="",
            FollowExcluded="Follow excluded",
            VendorMapRules<>"Set at base"
         ),
         " Profit lower than desired",
         ""
      ),
      IF(
         ISERROR(FloorPriceAdjusted*1),
         " Floor cannot be calculated",
         ""
      ),
      IF(
         AND(
            Disc="yes",
            MapRequired="yes",
            VendorMapRules<>"NO MAP"
         ),
         " MAP & disc",
         ""
      )
   )
)

Resources