Forum Discussion

Samantha Morgan's avatar
Samantha Morgan
Copper Contributor
Nov 14, 2017

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?

Formulas & Functions
Show and Tell
  • Arne Jæger's avatar
    Arne Jæger
    Copper Contributor
    Nov 14, 2017
    Something like this? IF(AND(Number>60,Number<65),Number*Factor,Number)
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Nov 15, 2017

    Another variant

    =A1*LOOKUP(A1,{-100,60.00000000001,65},{1,0.1,1})

    where in the second array constant are multipliers