formula to calculate value based on threshold
 

Friends,

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

thank you

formula to calculate value based on threshold
 

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

Thank you Claus. There is a mistake in my look up table. It should have referred to as $482000 and not up to $482000.

SO land values of $3770 and $366024 will have "0" values

how can we tweak your formula then ?

formula to calculate value based on threshold
 

Hi Thomas,

Am Thu, 18 Aug 2016 23:15:58 +0100 schrieb Excel Dumbo:

Thank you Claus. There is a mistake in my look up table. It should have
referred to as $482000 and not up to $482000.

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


Regards
Claus B.
--
Windows10
Office 2016

thank you very much claus