Notifications
Clear all
General Excel Questions & Answers
3
Posts
3
Users
0
Reactions
66
Views
Topic starter
Im doing a salary increase and i want is total compensation X rating (rating that i'll input will be automatic to the formula below)
2 - 2.5 = 3%
2.6 - 3 = 4%
3.1 - up = 5%
0 - 1 = 0%
Posted : 20/02/2019 6:48 am
Hi Mike
I suggest you use VLOOKUP.
Sunny
Posted : 20/02/2019 9:43 am
See also the example in: https://www.myonlinetraininghub.com/excel-forum/excel/how-many-if-functions-can-nest-1
Posted : 21/02/2019 4:51 am