software

Dear community members,
This is a small data I furnish below:

A B C DE
Total of B C D)
1.Ram53337017934812241231936841

2.Sam70037018934892412315138413. 167000 10000(-)600000
(B2-B1) (C2-C1) (D2-D1)

I want a total in E3 cell based on the following conditions:

1.If all columns in row 3 ( B/C/D ) shows plus figures then E2-E1
2.If any of the columns in row 3 (B/C/D) shows minus figures, then the sum
of such minus figures (irrespective of whether it is one column, two or
three )only to be shown in E3

Is there any formula in excel to do this? I am using excel 2003Dear Mr Franksta,

Thanks a lot for sparing your time and finding a solution. Even though it
involves two stage check process with a simple solution it has not stuck to
me. Any way it solved my problem and thank you once again.quot;