How to calculate value of one cell only what exceeds the other

2

What formula would you use to calculate a value above a given number?

Example: Area to calculate above 2.00M ². The multiplication value gave 2.75.

How do I register in the cell only the 0.75 - and in the same formula there is a value less than 2M² and do not stay in negative quantity. Ex: value of 0,40 = -1,60.

    
asked by anonymous 18.08.2015 / 06:21

1 answer

2

Just make a condition if it is greater than 2.00 make the difference, otherwise the value is:

A1 = 2,75
B1 = SE(A1>2;A1-2;A1)
B1 = 0,75

See more details about the SE function here .

    
18.08.2015 / 13:13