Forum Discussion
Solved
IF, AND, OR - HELP!
Hi! My son (who is a programmer, but doesn't use EXCEL) wrote me a formula I need for a spreadsheet. I'm VERY rusty using EXCEL, I need a bit of help translating what he sent me into an excel formula...
Replace all instances of CELL in the formula with L53.
The formula will return the discount. Let's say you enter the formula in M53.
The discounted amount will then be returned by the formula =L53-M53 in yet another cell, say N53.
Here is a slightly shorter version of the formula:
=L53*LOOKUP(L53,{0,150,200,250,300,500},{0,0.05,0.07,0.1,0.15,0.2})
Replace all instances of CELL in the formula with L53.
The formula will return the discount. Let's say you enter the formula in M53.
The discounted amount will then be returned by the formula =L53-M53 in yet another cell, say N53.
Here is a slightly shorter version of the formula:
=L53*LOOKUP(L53,{0,150,200,250,300,500},{0,0.05,0.07,0.1,0.15,0.2})
Thank you!!!! Worked like a charm! I appreciate your quick reply - you've truly made my day 100% better!