ExcelBanter - Help with IF Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Help with IF Formula (https://www.excelbanter.com/excel-worksheet-functions/51958-help-if-formula.html)

KAM

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

bpeltzer

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

KAM

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

All times are GMT +1. The time now is 08:36 AM.