Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Senior Member
 
Posts: 105
Default 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
Attached Files
File Type: zip Formula.zip (8.6 KB, 57 views)
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,872
Default 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
  #3   Report Post  
Senior Member
 
Posts: 105
Default

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 ?
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,872
Default 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
  #5   Report Post  
Senior Member
 
Posts: 105
Default

thank you very much claus
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to calculate differently based on original value Pam Excel Worksheet Functions 6 July 13th 09 04:41 PM
Formula to auto calculate based on other variables Scott A[_2_] Excel Worksheet Functions 8 June 22nd 09 03:10 PM
How to populate a cell based on font color/threshold ascottbag-hcm Excel Worksheet Functions 1 May 28th 09 09:22 AM
formula calculate charges based on hours Pammy Excel Discussion (Misc queries) 1 September 4th 07 07:54 PM
I need a formula to calculate rates based on current age Martha Excel Worksheet Functions 3 July 10th 07 03:50 PM


All times are GMT +1. The time now is 03:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"