=IF(E8-E11-E12-E13-E14-E15-E16-E17+E18+E19-E20-E21-E22=0,"
",E8-E11-E12-E13-E14-E15-E16-E17+E18+E19-E20-E21-E22)

This formula will work but you could probably plan things out better
depending on how often you are doing these calculations and if the format of
them will be the same. What is your real data like? As in what are you
trying to accomplish?

"Jay" wrote:

Okay, thanks Tim:

Now I have another question for you guys. How can I in one action do
subtraction and or addition of all values vertically in the cells downwards
and avoid a "0" showing in the target cell say cell E40? Example; E8 -
E11-E12-E13-E14-E15-E16-E17, then maybe a "+" E18+E19, then "-" E20-E21-E22?
How would that work?

Thanks,


"tim m" wrote:

=IF(C6="","",$B$40*C6)
Put the above formula in C40

Format cell C40 like this
Format...cells...number....then choose red color for negative numbers


"Jay" wrote:

Hi guys:

This should be quick! What I'd like to do is calculate in cell C40 to
resulting value of say 9.5% of the amount in cell C6, which is 15,000. But,
I'd also like not to have a zero value show-up in the target cell if there is
no value in cell C6. The percentage value is listed in cell B40. When this
percentage value in cell B40 changes, the result in cell C40 should reflect
that change. If it becomes a negative value, have it show-up in RED. Is this
possible?

Thanks,