output negative result will show zero value
 

hi community

how can i create a formula that show this output....


worksheet A

worksheet B

worksheet C

worksheet A - worksheet B, if output is negative, worksheet C will show zero
value

but

worksheet A - worksheet B, if output is positive, worksheet C will show its
value as usual


can anybody kindly guide me on this...



thanks community for the assistance


:)
--
oldLearner57

output negative result will show zero value
 

I wonder if the following is what you are looking for. In C1:

=max(0, A1 - B1)


On Apr 22, 5:09*pm, oldLearner57
wrote:
hi community

how can i create a formula that show this output....

worksheet A

worksheet B

worksheet C

worksheet A - worksheet B, if output is negative, worksheet C will show zero
value

but

worksheet A - worksheet B, if output is positive, worksheet C will show its
value as usual

can anybody kindly guide me on this...

thanks community for the assistance

:)
--
oldLearner57

output negative result will show zero value
 

My best guess...

=MAX(Sheet1!A1-Sheet2!A1,0)

--
Biff
Microsoft Excel MVP


"oldLearner57" wrote in message
...
hi community

how can i create a formula that show this output....


worksheet A

worksheet B

worksheet C

worksheet A - worksheet B, if output is negative, worksheet C will show
zero
value

but

worksheet A - worksheet B, if output is positive, worksheet C will show
its
value as usual


can anybody kindly guide me on this...



thanks community for the assistance


:)
--
oldLearner57

output negative result will show zero value
 

On Tue, 22 Apr 2008 18:09:00 -0700, oldLearner57
wrote:

hi community

how can i create a formula that show this output....


worksheet A

worksheet B

worksheet C

worksheet A - worksheet B, if output is negative, worksheet C will show zero
value

but

worksheet A - worksheet B, if output is positive, worksheet C will show its
value as usual


can anybody kindly guide me on this...



thanks community for the assistance


:)

When you write "show", I am assuming you mean "display", but that you still
want the correct result stored in the cell.

That being the case, custom format the cell something like:

General;\0;General

The second section is for negative numbers, and the format will have it display
a literal "0" if the number is negative. The true result will still be in the
cell, however.

To custom format, right click on the cell and select "Format Cells" from the
drop down menu. Then select the Number tab; Custom and Type: the above
--ron

output negative result will show zero value
 

it can be done like this =if(worksheet A - worksheet B < 0,0,worksheet A -
worksheet B)

"oldLearner57" wrote:

hi community

how can i create a formula that show this output....


worksheet A

worksheet B

worksheet C

worksheet A - worksheet B, if output is negative, worksheet C will show zero
value

but

worksheet A - worksheet B, if output is positive, worksheet C will show its
value as usual


can anybody kindly guide me on this...



thanks community for the assistance


:)
--
oldLearner57