LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Chris White feeling dumb!
 
Posts: n/a
Default Moving formulas

Hi this is stupid I've done it before, but now can't get it right.
I want to create a formula that adds 2% to a whole range of fields.
if I use for example =sum(c2)+(c2*0.02) and try to put that in cell c2 it
says circle no allowed. if I put this formula in say d3 no prob and I can
move the formula down in the D column and the c2 goes c3,c4,c5 etc. but I
don't want to use a new column.. help please
Chris

auto reply won't work as it's a hotmail and I don't use that really
 
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
Help, Urgent Excel Formulas are not calculating maashoff Excel Discussion (Misc queries) 1 May 3rd 05 12:25 AM
pasting or moving formula cells without updating formulas jake Excel Discussion (Misc queries) 2 April 14th 05 01:02 PM
Problem with named formula's nathan Excel Worksheet Functions 0 January 21st 05 04:07 PM
Moving columns with VLOOKUP formulas Brad Excel Worksheet Functions 3 January 12th 05 03:12 AM
calculating formulas for all workbooks in a folder Chad Excel Worksheet Functions 3 November 13th 04 05:22 PM


All times are GMT +1. The time now is 08:11 AM.

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

About Us

"It's about Microsoft Excel"