Forum Discussion

stuart taylor's avatar
stuart taylor
Copper Contributor
Aug 01, 2018

If formulas

Can anyone guide me on how to write an IF formula where I'm saying that depending on the percentage value in one cell then I will apply another percentage in another cell?  i.e. if Cell E5 is between 0% & 10% apply 100% to Cell F5, If Cell E5 is between 10% and 20% apply 125% to Cell F5 etc etc?

excel
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Aug 01, 2018

    Hi Stuart,

     

    For data structured like this

    it'll be

    =LOOKUP(E5,$C$4:$C$7,$D$4:$D$7)