Formula greater than
 

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
--
Mel

Formula greater than
 

B4: =IF(A46,A4-6,"")
--
John C


"Mel" wrote:

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
--
Mel

Formula greater than
 

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.

--
Biff
Microsoft Excel MVP


"Mel" wrote in message
...
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
--
Mel