total to large show discrepancy

Glenjamin

New Member
Joined
Sep 30, 2014
Messages
11
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

thanks in advance

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
Joined
Aug 14, 2014
Messages
598
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

thanks in advance

Glen.

Hi, and welcome :)

I think this is what you want

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

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,425
Office Version
  1. 2019
If I've understood this correctly

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

Glenjamin

New Member
Joined
Sep 30, 2014
Messages
11
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.
 
Master Excel Bundle

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.

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top