Forum Discussion
IF Statement
Hi, I can't work out the formula I need for this problem: So basically the calculation is if a number is more than 60 but less than 65 I want to multiply by a percentage. Any advice?
Another variant
=A1*LOOKUP(A1,{-100,60.00000000001,65},{1,0.1,1})where in the second array constant are multipliers