Forum

Notifications
Clear all

Please help with IF formula

3 Posts
3 Users
0 Reactions
66 Views
(@mikes05)
Posts: 1
New Member
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
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Mike

I suggest you use VLOOKUP.

Sunny

 
Posted : 20/02/2019 9:43 am
(@fravis)
Posts: 337
Reputable Member
 

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
Share: