| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to calculate differently based on original value | Excel Worksheet Functions | |||
| Formula to auto calculate based on other variables | Excel Worksheet Functions | |||
| How to populate a cell based on font color/threshold | Excel Worksheet Functions | |||
| formula calculate charges based on hours | Excel Discussion (Misc queries) | |||
| I need a formula to calculate rates based on current age | Excel Worksheet Functions | |||
Hybrid Mode
