Formula greater than

[Mel]

Hi
I was wondering whether you can help with a problem I have, for example
IF cell A4 totals 9 how can I write a formula in cell B4 to to say A4 >6 and
put the remaining total into B4 ie 3. hope this makes sense.
That was random numbers, but what I need to do is anything more than the
number I specify I want the remaining total to show in cell B4
Regards

 

[John C]

B4: =IF(A4>6,A4-6,"")

 

[T. Valko]

You haven't said what should happen if A4<6. So, maybe something like this:

=MAX(0,A4-6)

If A4<=6 the formula returns 0.