sugar

Need to deduct raw material quantity once the sale is happened for finished good. Example a cake of 1 kg will have different ingredients like sugar 20gm, baking powder 20gm, etc. So if I sell 1 kg cake automatically the ingredient should be deducted from stock. So if I have sugar say 100gm in...

I want to check if the value of a cell is written as 100 gram (or a different number) instead of 100gr. Example: 100gr white sugar is wrong 100 gram white sugar is right or 38gr cinnamon is wrong 38 gram cinnamon is right I have tried several formulas but I'm always stuck with the space...

I have a list of supplies in Column A and prices in Column B. I am constantly adding rows of data to the worksheet. I want to get the highest Value for "Sugar" and also the highest value for "Lemons". Is there a way to combine an IF Supply = "Sugar" with a Max function?

Hi all i have this: A1=Apple with sugar at A2=Apple with salt at bottom A3=Chese cream with banana and in: h1=1 j1=Apple h2=2 j2=Chese cream h3=3 j3=Orange h4=4 j4=Table i want in B1 know if A1 start with any value of j if yes put the h column in this case: A1=Apple with sugar at...

Hi , i have data in column A, B ,C but i need to insert new row above active cell in coloum B original format <colgroup><col><col><col></colgroup><tbody> A B C 4 APPLE SUGAR MILK WATER 5 BANANA SUGAR MILK WATER 10 MANGGO SUGAR MILK...