How about simplifing the modified original formula as well to read:

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

--
Thanks,
Shane Devenshire


"driller" wrote:

let try getting rid of nest..
with this one
=AND(C6C3,C3=C16,C16C6)*(C3-C16)+ABS(AND(C6=C16,C16<=C3)*(C16-C6))
copy n paste..
--
*****
birds of the same feather flock together..



"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