# total to large show discrepancy

#### Glenjamin

##### New Member
Hi,

this is my first post and would appreciate any help i can get. this is probably a simple task to the excel educated mind but i'm struggling to make it work.

so...

I am working on a new CMM report spreadsheet. I have Tolerance (E53), Bonos (F53), True position (G53) and OOT (H53). What I am looking to do is have the OOT cell show the discrepancy if true position is larger than tolerance + bonos, otherwise OOT just remains at 0.

hope this explains the problem well enough and again any help would be great

Glen.

### Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

#### Arithos

##### Well-known Member
Hi,

this is my first post and would appreciate any help i can get. this is probably a simple task to the excel educated mind but i'm struggling to make it work.

so...

I am working on a new CMM report spreadsheet. I have Tolerance (E53), Bonos (F53), True position (G53) and OOT (H53). What I am looking to do is have the OOT cell show the discrepancy if true position is larger than tolerance + bonos, otherwise OOT just remains at 0.

hope this explains the problem well enough and again any help would be great

Glen.

Hi, and welcome

I think this is what you want

=IF(G53>(E53+F53),G53-(F53+E53),0)

#### Special-K99

##### Well-known Member
If I've understood this correctly

in H53
=IF(G53 > E53+F53, G53-(E53+F53),0)

#### Glenjamin

##### New Member
thanks very much folks for your swift responses. Nice easy one to start your day by the looks of things works perfect. Im a designer by trade just starting to learn excel. I almost had it correct but not quite.

thanks again..

Glen.

Replies
1
Views
45
Replies
3
Views
358
Replies
2
Views
262
Replies
1
Views
1K
Replies
8
Views
226