Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vacation
 
Posts: n/a
Default Keep formual intact after deleting a line

My formula reads =sum(a5+f5+g5+l5)*0.75. This represents items I want to tax
out of a larger range of items. I want to be able to delete one or more of
those lines (like af and g5) and still have the formula produce a result, not
REF! Is this possible?
Thank you
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arvi Laanemets
 
Posts: n/a
Default Keep formual intact after deleting a line

Hi

Don't delete - use Clear Contents instead

Arvi Laanemets


"vacation" wrote in message
...
My formula reads =sum(a5+f5+g5+l5)*0.75. This represents items I want to

tax
out of a larger range of items. I want to be able to delete one or more of
those lines (like af and g5) and still have the formula produce a result,

not
REF! Is this possible?
Thank you



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
strange horizontal line showing accross several columns Thrava Excel Discussion (Misc queries) 4 June 29th 05 03:33 AM
coloring overy other line without doing so line by line gen Excel Worksheet Functions 5 April 1st 05 10:38 PM
Formatting lines between data points in a line chart ltanner Charts and Charting in Excel 2 March 13th 05 05:12 AM
Line chart - date line association gone mad! Johannes Czernin Charts and Charting in Excel 5 January 17th 05 08:48 PM
Macro - Skipping a line PaulPoll Excel Worksheet Functions 4 December 21st 04 12:43 AM


All times are GMT +1. The time now is 12:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"