Subtract command?

[kinkyparamour]

Hello,

Is there a command like sum which will subtract the values in a range of cells?

Thank you,
Denny

 

[Guest]

Why not use Sum(A1,-A2) format?
I can't find Subtract in Excel

 

[kinkyparamour]

sum(a1-a2)is good but I want to do a1:a20. Any ideas besides a1-a2-a3 and so.......

Denny
This message was edited by kinkyparamour on 2002-02-23 20:22

 

[pilot]

This should work. Assume subtracting A2:A20 from A1.

=A1-SUM(A2:A20)

 

[kinkyparamour]

That works great. So simple, why didn't I think of it?

Thanks again,
Denny