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

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

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.

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,168,030
Messages
5,856,935
Members
431,841
Latest member
jaybeem

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back