Excel if cell exceeds certain value use difference

excel excel-2011
Ray picture Ray · Nov 22, 2013 · Viewed 15.5k times · Source

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.

Answer

Black.Jack picture Black.Jack · Nov 22, 2013 
=if(B3>1600;B3-A3;"")

Honestly i didn't catch the other operand of the difference you describe, but that is the If formula..

hope it helps..

Related questions

Reordering Chart Data Series

How does one reorder series used to create a chart in Excel? For example, I go to the chart, right click > Select Data. In the left column I see series 1, series 2, to series n. Say, I want to move …

Read More
Disable all dialog boxes in Excel while running VB script?

I have some code in VB that saves all XLSM files as XLSX. I already have the code that will do that for me, but dialog boxes show up for every action. This was fine for a few dozen files. …

Read More
Array formula on Excel for Mac

I need to call LINEST in Excel 2011 for Mac, I would say - this was a detective story. My laziness, my curiosity, all was here! I had a homework from university course to use LINEST. I even stopped trying to …

Read More