• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to...Add even incremental changes to range of values???

S

Smitty15

New Member
I have a range of values C3:C100 that have been offset from a separate worksheet based on meeting certain conditions. If the conditions are not met, the cell value is returned as #N/A. The values that met the conditions return their numberic value. In order to chart the duplicate values on a scatter cha so that they do not overlap, I would like to create a even incremental change to each of these duplicates to resemble something like this...


C3 = C3

C4 = C3+0.25

C5 = C4+0.25

C6 = C5+0.25


Any idea how I can write a formula like this?
 
Why not

D3 = C3

D4 = C3+0.25

D5 = C4+0.25

D6 = C5+0.25

And plot Col D instead of C
 
You must log in or register to reply here.
Back
Top