Forum Discussion
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...
Hi Stuart,
For data structured like this
it'll be
=LOOKUP(E5,$C$4:$C$7,$D$4:$D$7)