excelexcel-2011

Excel if cell exceeds certain value use difference

I can't come up with the right formula for this.

Cell B3 contains a value. In cell C3 is the formula which should calculate: if B3 exceeds 1500, i want it to display the difference. E.g. IF value of B3 is 1600, C3 should display 100.

Thanks, can't get my head around it.

Solution

  • If you want it to show the value of B3 when that value is less than or equal to 1500, and to show the difference if it is greater, use the following:

    =IF(B3>1500,B3-1500,B3)

    If you want it to show nothing if it is less than or equal to 1500, use:

    =IF(B3>1500,B3-1500,"")