Forum Discussion

Parth25's avatar
Parth25
Copper Contributor
Aug 16, 2022

Matching Values in formula with IF

I am a Jewellery Business owner and it is important for me to manage my inventory at the same time keeping a track of my rates as there are lots of variables that come in to play....   My problem i...
excel
Formulas and Functions
Parth25's avatar
Parth25
Copper Contributor
Aug 16, 2022
Hey Harun24HR,

I tried your method but it is still not functioning properly
Harun24HR's avatar
Harun24HR
Bronze Contributor
Aug 16, 2022
It must work. I think problem is in your IF() function logic. All the IF() result is not less than 0.065. Can you share a dummy workbook with fake data and explain where it is not functioning properly?
  • Parth25's avatar
    Parth25
    Copper Contributor
    Aug 16, 2022

    everytime i am trying to use the formula it is asking me to open a file from system. 

    Harun24HR 

    • Harun24HR's avatar
      Harun24HR
      Bronze Contributor
      Aug 16, 2022
      Did you download my attached file and check?
      • Parth25's avatar
        Parth25
        Copper Contributor
        Aug 16, 2022

        Harun24HR 

         

        i am trying to share the file but it says the file type (.xlsx) is not supported

Resources