Hello! :) I am trying to work on an IF/AND nested excel formula, below is what I want it to do:
If D7's value is 60-69%, then multiply 'Inventory Data'!D9 by (1+.10)
If D7's value is 70-79%, then multiply 'Inventory Data'!D9 by (1+.20)
If D7's value is 80-89%, then multiply 'Inventory Data'!D9 by (1+.30)
If D7's value is 90-99%, then multiply 'Inventory Data'!D9 by (1+.40)
If D7's value is 100-500%, then multiply 'Inventory Data'!D9 by (1+.50)
This is the formula I put together, but it won't go past the first set of criteria and just multiplies it by (1+10) to gross it up 10%, even though it is at 95% and should fall in the criteria where it needs to be multiplied by (1+40) . Thank you so much for your help
Solved by I. D. in 20 mins