Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to: have something equal Cx where x=8+ C4
Hi,
I am sure there is a really simple solution to this one. I have a cell that equals an average, eg =Average(C5:C10), which i have filled for about 400 rows. I want to easily have one cell where i can edit a value, say from 5 to 10, which would then increase the difference between C5 and C10 to C5 and C15. I am pretty new to excel, dont have much of an idea, but i would like to avoid having to refill every time i want to change that value. I attemped =average(C5:C(5+A1)) where A1 equaled the value, but that just returned with an error. Any help is appretiated |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I make cell "yes" equal 1, "no" equal 0 | Excel Discussion (Misc queries) | |||
#ref to equal zero | Excel Worksheet Functions | |||
Contains instead of Equal | Excel Worksheet Functions | |||
not equal to zero | Excel Worksheet Functions | |||
Getting 0 to equal 1 | Excel Worksheet Functions |