View Single Post
  #2   Report Post  
bpeltzer
 
Posts: n/a
Default 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