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

Asked

Viewed 952 times

2

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

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

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

excel phpexcel

1 answer

2

Just make a condition if it’s more than 2.00 make a difference, or else the value is:

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

See more details about the function SE here.

Browser other questions tagged excel phpexcel

You are not signed in. Login or sign up in order to post.