I am trying to assign multiple conditions to a cell in excel using the IF formula.
What I want to achieve is that if the value of cell A is greater than 12000, but less than 75000, then the operation to be performed is to multiply the value of cell A by 0.1. In turn, I want that if the value of A is less than or equal to 1000 then the value of the cell with the formula will always be 100.
