Forum Discussion
stuart taylor
Aug 01, 2018Copper Contributor
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...
SergeiBaklan
Aug 01, 2018Diamond Contributor
Hi Stuart,
For data structured like this
it'll be
=LOOKUP(E5,$C$4:$C$7,$D$4:$D$7)