|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
04-30-2004, 07:23 PM
|
#1 |
|
Security Dude
Staff
Join Date: Jun 2003
Location: Derby, Kansas
Posts: 999
   |
Excel Formula Help needed
I am trying to get Open Office (spreadsheet) to compute the value of cell E2, minus the range b2:b20. I tried:
=E2-(B2:B20) with and without the ( and ). We also tried this on Excel 2003 and got a #value! error. Can you give me any suggestions on how to do this? Thanks.
__________________
Tyler A. Thompson Small Business Networking Services Specialist tyler@derbydigital.com |
|
|
|
04-30-2004, 07:43 PM
|
#2 |
|
Member (10 bit)
Join Date: Jan 2001
Location: Greenville, MS
Posts: 625
|
You can sum b2:b20 in another cell and subtract it from e2.
|
|
|
|
|
04-30-2004, 07:55 PM
|
#3 |
|
Security Dude
Staff
Join Date: Jun 2003
Location: Derby, Kansas
Posts: 999
|
good idea, thanks.
|
|
|
|
|
04-30-2004, 08:11 PM
|
#4 |
|
Member (10 bit)
Join Date: Jan 2002
Location: Edmonton, AB, Canada
Posts: 628
|
=E2-SUM(B2:B20)
|
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
