The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Formula for functions type n+1 - n		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

KMPA

Norway
1 Posts
Posted - 03/06/2018 :  05:20:50 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hi! I have a column A with values A1, A2, A3, A4, A5, etc. In column B I would like to have the following values: B1=A2-A1, B2=A3-A2, B3=A4-A3, B4=A5-A4, etc. How can I use the formula option to make it possible?

Castiel

343 Posts
Posted - 03/06/2018 :  05:37:05 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by KMPA

Hi! I have a column A with values A1, A2, A3, A4, A5, etc. In column B I would like to have the following values: B1=A2-A1, B2=A3-A2, B3=A4-A3, B4=A5-A4, etc. How can I use the formula option to make it possible?

diff(A)



Edit: How come this 404 Error and not showing the image above?


     #####
    #### _\_  ________
    ##=-[.].]| \      
    #(    _\ |  |------|
     #   __| |  ||||||||
      \  _/  |  ||||||||
   .--'--'-. |  | ____ |
  / __      `|__|[o__o]|
_(____nm_______ /____\____
Edited by - Castiel on 03/06/2018 05:41:07 AM
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000