Thread: IF excel, excel doesn't want to play ball
View Single Post
 
Old 07-27-2016, 05:35 PM
Joonnoo Joonnoo is offline Windows 10 Office 2016
Novice
  
Join Date: Jul 2016
Posts: 3
Joonnoo is on a distinguished road
Default IF excel, excel doesn't want to play ball
=IF(I21>3000,I22*10%,IF(I21,>3000<50000,I22*8%,IF( I21>50000,I22*)))

hello, could you please help, i need to
IF I21 is less than 3000 it needs to be times by 10 %
IF I21 is equal to 3000-50 000 it needs to be times by 8 %
IF I21 is greater than 50 000 it needs to be times by 6%

above is my attempt

thank you and sorry

Reply With Quote