Is this what you want?

=IF(C3<C6,MAX(C3-C16,0),IF(C16-C6<=0,ABS(C16-C6),0))

HTH
Kostis Vezerides

PattiP wrote:
We have the following formula in a worksheet:

=IF(C3<C6,C3-C16,IF(C16-C6<=0,ABS(C16-C6),0))

In the second statement "C3-C16", we would also like to include if C3-C16 <
0, enter a "0" in the cell. Otherwise, just calculate C3-C16.

Any help would be appreciated!

Patti



--
Patti