Everything I've tried is not working. Can you add, if the value is greater than $200 then round, to this formula?
=IF(E4<=15,E4*2,IF(E4<=50,E4*1.95,IF(E4<=100,E4*1.9,IF(E4<=300,E4*1.85,IF(E4<=500,E4*1.8,IF(E4<=1000,E4*1.75,IF(E4<10000000,E4*1.7)))))))*1.06
Thank you in advance!
=IF(E4<=15,E4*2,IF(E4<=50,E4*1.95,IF(E4<=100,E4*1.9,IF(E4<=300,E4*1.85,IF(E4<=500,E4*1.8,IF(E4<=1000,E4*1.75,IF(E4<10000000,E4*1.7)))))))*1.06
Thank you in advance!