Return a number only if greater than another number?

[FYRGUY]

Greetings,
I am using MS Excel.

In a single worksheet, I am trying to sum cells F17 & O21 and put the answer in cell O22. I have a certian critera that follows. I have tried =IF and =SUMIF and can't seem to figure it out. Probably simple but I am out of attempts. Here is what I am trying to do spelled out, followed by my attempts at a function

If F17+O21 are >216, display the number over "216" in O22. If F17+O21 are <=216, leave O22 blank.

=IF((F17+O21)>216,(F17+O21)-216,(F17+O21))
+SUMIF(F17+O21,>216,F17+O21)

I hope my problem is glaring, but I can't find it. Please help if you can.

Chris

 

[missinglinq]

You're in an MS Access forum! This needs to be in:

VBA Visual Basic for Applications (Microsoft) Forum!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[FYRGUY]

Sorry, & thanks