Hi Joseph,

Am Mon, 15 Aug 2016 23:20:17 +0100 schrieb Excel Dumbo:

Please see attached file and if you could please suggest a single
formula that will provide the value and

two separate formula that will shows the thresholds separately

in G2 try:

=IF(F2<=2947000,100+MAX(0,F2-482000)*0.016,39540+MAX(0,F2-2947000)*0.02)


Regards
Claus B.
--
Windows10
Office 2016