Posted to microsoft.public.excel.misc
|
|
if the # is a negative #, then show 0
=MAX(0;yourformula)
Regards,
Stefi
ezt *rta:
I cant seem to figure out how to make a formula that when it performs its
calculation and the answer is a negative #, i want it to just show "0".
Is it a IF command?
thanks
|