incentive calculation

[mjsureraja]

Dear team,
I want to calculate below mentioned incentive data pls help.
Sale is less than 15000 incentive is 30
Sale is 15001 to 25000 incentive is 60
Sale is more than 25001 incentive is 100
Thanks in advance

Regards,
Sureahraja.M

 

[AhoyNC]

Like this?

Excel Workbook
	A	B
1	Sale	Incentive
2	17800	60
Sheet

 

[mjsureraja]

Hi ahoync,
Very thank you. But when I put zero in that column that shows 30 that should be zero pls help

 

[gaz_chops]

Try

=LOOKUP(A2,{0,1,15001,25001},{0,30,60,100})

 

[AhoyNC]

Formula from gaz_chops above will work or you could change my formula to:

=IF(A2=0,0,IF(A2<15001,30,IF(A2<25001,60,100)))