output negative result will show zero value

O

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


:)
 
R

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


:)
Click to expand...

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
 
A

anas

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