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?
Something like this? IF(AND(Number>60,Number<65),Number*Factor,Number)
| 100 | #NAME? |
I must be doing something wrong