output negative result will show zero value

[oldLearner57]

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

 

[joeu2004]

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

=max(0, A1 - B1)

 

[T. Valko]

My best guess...

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

 

[Ron Rosenfeld]

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

 

[anas]

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