Forum Discussion

Madi_LF1968's avatar
Madi_LF1968
Copper Contributor
Jan 10, 2020
Solved

IF Formula

I'm trying to use IF formula on this scenario If an item is product code : ABC, then use the quantity for product ABC to divide by 100 and if the product is not product code : ABC, then use the quan...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Jan 11, 2020

    Madi_LF1968 

    With this sample

    first formula could be

    =D3/((C3<>"LSSM-5888")+1)/100

     

    But it's much better to have helper table (on the right) with paperbags per item against code. When the formula (second table below) will be

    =D10/VLOOKUP(C10,H3:$I$6,2,FALSE)

    Please check in attached file.

Madi_LF1968's avatar
Madi_LF1968
Copper Contributor
Jan 11, 2020

SergeiBaklan 

 

Thank you very much Sergei. Your formula worked. 

 

Thanks again. 

Resources