If greater than, then x% and value of %.

[books4cars]

I have a formula that starts like this:
=if(K18 < 200000,[right(3%,[1]

If K18 is greater than 200000 than I need to show "3%" in the cell to the left and the value of 3% two cells to the left. If greater than 300000 then 4%. If greater than 400000 then 5% etc.

Thanks

 

[stefankemp]

Format I18 as % and then in I18:

=(INT(K18/100000)+1)/100

In J18:

=TEXT(I18,"0%")