How do I write an Excel formula so that the values I input into d1 to d5 cells would subtract from home stock quantity?
"What formula should i use in excel for the following scenario :: if cell 1 value is >0 and < 30 then input ""0 - 30"" in cell 2, if cell 1 value is >=31 and < 45 then input ""31 - 45"" in cell 2, if cell 1 value is >=46 then input ""46+"" in cell 2?"