Nested IF statement
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
|