| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Help with IF Formula
Can anyone help me with a formula for this? If the cell is greater than
8800, the first 2000 above 8800 is multiplied by 100. Anything over the first 2000 is multiplied by 92. Thanks for your help |
|
#2
|
|||
|
|||
|
Help with IF Formula
=IF(A18800,IF(A110800,2000*100+92*(A1-10800),(A1-8800)*100),0)
"KAM" wrote: Can anyone help me with a formula for this? If the cell is greater than 8800, the first 2000 above 8800 is multiplied by 100. Anything over the first 2000 is multiplied by 92. Thanks for your help |
|
#3
|
|||
|
|||
|
Help with IF Formula
Thanks so much for your help.
"bpeltzer" wrote: =IF(A18800,IF(A110800,2000*100+92*(A1-10800),(A1-8800)*100),0) "KAM" wrote: Can anyone help me with a formula for this? If the cell is greater than 8800, the first 2000 above 8800 is multiplied by 100. Anything over the first 2000 is multiplied by 92. Thanks for your help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula? | Excel Worksheet Functions | |||
| writing a formula for a colored value | New Users to Excel | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Simplify formula | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
