Forum Discussion

Copper Contributor

Apr 27, 2020

Solved

Help with IF function

Hi everyone.. first time on this forum. I am trying to calculate a result based on 4 sets of values. Scenario is: Client X sells $XX (Value 1) and grows by X% (Value 2) and is paid according to (Va...

Formulas and Functions

Riny_van_Eekelen
Apr 28, 2020
dameb72 Try the attached schedule again. I've made it to look more like your example.
dameb72.xlsx9 KB

dameb72

Copper Contributor

Apr 27, 2020

Wyn Hopkins Thanks for this tip. I am also a novice with VLOOKUP. SO I can search a range of fields yes in order to assign the right remuneration percentage.

Riny_van_Eekelen

Platinum Contributor

Apr 28, 2020

dameb72 Try the attached schedule again. I've made it to look more like your example.

dameb72.xlsx9 KB

dameb72
Copper Contributor
Apr 28, 2020
Riny_van_Eekelen Thanks !This is exactly what I was after!
- Riny_van_Eekelen
  Platinum Contributor
  Apr 28, 2020
  dameb72 You're welcome!