Formula greater than

  • Thread starter Thread starter Mel
  • Start date Start date
M

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
 
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.
 
Back
Top